Page 25 - TP_Prime_V2.2_Class7
P. 25

Notice that only the details of the students who have obtained marks greater than 80 are
                 displayed and the remaining rows remain hidden.


                  Removing Filters


                 The filters once applied can be easily removed. Click anywhere in the worksheet and repeat
                 steps to apply filters. You will notice that the filter arrows in front of column headers

                 disappear and the hidden rows also reappear.                                                               ADVANCED FEATURES OF EXCEL

                  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 these steps:
                                                                                                                          23
                 Step 1:  Select the data to which formatting is to be applied.

                 Step 2:  Click on the Conditional Formatting command from Styles group under Home tab.
                           A drop-down list appears. This list 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   21   22   23   24   25   26   27   28   29   30