Page 51 - Digicode_AI_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.





















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