Basic HTML Version

|  | Table of Contents |  | View Full Version

Page 32 - 2626_South Point_C-7
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 |