Page 32 - TP_Pluse_V2.2_Class_7
P. 32
Step 2: Select the Number Filters option. A sub-menu opens.
Step 3: Select the Greater Than option.
The Custom AutoFilter dialog box appears.
Step 4: 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 Plus (Ver. 2.2)-VII

