Page 51 - Dig_CodeAI_V2.1_Class_7
P. 51

4  Enter the
                            value.                                                          5  Click on the
                                                                                            OK button.


                 This list shows various criteria like:

                 •   Highlight Cells Rules: This option is selected when you want to highlight all cells satisfying a
                   given condition. When you hover mouse 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 mouse 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 mouse over this option, it opens a sub-list showing bars of different types
                   and colours that can be added to the cells.
                 •   Colour 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 mouse 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 is hovered over this option.

                 The selected conditional formatting is applied to the selected cell range. 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.



























                                  If Excel was a magical library, how would you sort books, and filter books you had read?





                                                                             Advanced Features of Excel 2016  49
   46   47   48   49   50   51   52   53   54   55   56