Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 34 - 2629_Devagiri_C-7
P. 34

    CONDITIONAL FORMATTING

                      Conditional  Formatting  allows you  to  apply  formatting  (such  as  colours  or  styles)  to  cells
                      automatically based on their values. This makes it easier to highlight important data and trends
                      for quick analysis.
                      To apply Conditional Formatting, follow the given steps:

                                 2    Click on the Conditional Formatting option.

                                                                                  3    Hover your mouse pointer over Highlight
                                                                                  Cells Rules and select Less Than.

                                1    Select the range of cells you want to format.

                                                                            4    Enter the value and
                                                                           select the formatting style.

                                      5    Click OK to apply the formatting.

                      The cells with values less than the specified number will be highlighted with the selected format.

                                                                 Ask
                                                                           AGENT
                                                            OrangeAI
                        Prepare a worksheet that applies Excel formulas and functions to solve practical problems.

                               Study

                             CHARTS IN EXCEL

                      Charts are powerful tools that help you visually represent data, making it easier to analyse and

                      communicate insights. They allow you to quickly identify trends, patterns and comparisons in
                      your data.

                       32
                            Premium Edition-VII

| 29 30 31 32 33 34 35 36 37 38 39 |