Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 21 - 2607_Trackpad_Pro_5.1_flipbook_C7
P. 21

    CONDITIONAL FORMATTING

                      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 the given steps:

                                                                  1  Select the data and click on the
                                                                 Conditional Formatting command.

                                                                                                     2  Select the
                                                                                                    desired option.

                                                                                                     3  Choose
                                                                                                    desired fill effect.

                      The list under Conditional Formatting shows various criteria like:

                         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.

                       20   Premium Edition-VII

| 16 17 18 19 20 21 22 23 24 25 26 |