Page 66 - modular4.0
P. 66
Chapter Profile
5 Enter 80 in
the criteria box. 6 Click on the
OK button.
Notice that only the details of the students who have obtained marks greater than 80 are displayed
and the remaining rows get hidden.
Remove 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.
Clickipedia
The filter can also be applied through Sort & Filter group under the Data tab by selecting
Filter command .
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 2 Select the desired
Conditional Formatting command. conditional formatting.
3 Now select the desired
option to apply on the
selected cell range.
The selected conditional formatting is applied to the selected cell range.
64 Modular (Ver. 4.0)-VII

