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.

