Page 22 - TP_V5.1_C7_fb
P. 22

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 Formating 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
   17   18   19   20   21   22   23   24   25   26   27