Page 26 - TP_Plus_v4_Class7
P. 26

CONDITIONAL FORMATTING


              Conditional formatting in Excel allows you to automatically format cells based on specific conditions or
              criteria. Suppose you do not want to hide any rows but still want to highlight all the cells that satisfy a
              condition, for example greater than 80. This type of formatting is known as Conditional Formatting in
              Excel. To apply conditional formatting to a series of data, follow these steps:


                     1   Select the data and click on the       Select  the   desired   2
                         Conditional Formatting command.        conditional formatting.







                                                                                      Now select the desired
                                                                                      option to apply on the   3
                                                                                      selected cell range.
















              The conditional formatting command has following options:

                   Highlight Cells Rules: This option is selected when you want to highlight all the cells satisfying a
                 given condition. When you hover the mouse pointer over this option, it opens a sub-list showing
                 criteria like Greater Than, Less Than, Equal To, Between, etc.

                   Top/Bottom Rules: This option is selected when you want to highlight some top or bottom number
                 of items in a data series. When you hover the mouse pointer over this option, it opens a sub-list
                 showing criteria like Top 10 Items, Top 10%, Bottom 10 Items, Bottom 10%, etc.
                   Data Bars: This option is selected when you want to add data bars to the cells having numeric data.
                 When you hover the mouse pointer over this option, it opens a sub-list showing bars of different
                 types and colours that can be added to the cells.

                   Color Scales: This option is selected when you want to add colour schemes to all selected cells
                 slowly varying from top to bottom items. When you hover the mouse pointer over this option, it
                 opens a sub-list showing different colour variations that can be added to cells.

                   Icon Sets: This option is selected when you want to add icon sets to show which cells are acceptable,
                 which are moderate and which need attention. The different types of icon sets that can be added are
                 shown in the sub-list that opens when the mouse pointer is hovered over this option.
              You can also define  your own  rule for highlighting  cells by  selecting  New Rule option  from the
              Conditional Formatting drop-down list. The conditional formatting features applied to a data range
              can be cleared by selecting Clear Rules option from the Conditional Formatting drop-down list.



                  24  Plus (Ver. 4.0)-VII
   21   22   23   24   25   26   27   28   29   30   31