Page 32 - Plus_V2.2_C7_Flipbook
P. 32

Step 3:  Place your mouse over the Number Filters option. A sub-menu opens.

                  Step 4:  Select the Greater Than option.

                  The Custom AutoFilter dialog box appears.
                  Step 5:   Enter 80 in the criteria box and click on
                          the OK button.











                             Custom AutoFilter dialog box

                                                                                    Applying custom filter



                  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.



                         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:
                  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.



                  30    Premium Edition-VII
   27   28   29   30   31   32   33   34   35   36   37