Page 22 - TP_V5.1_C7_fb
P. 22
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
Conditional Formatting command.
2 Select the
desired option.
3 Choose
desired fill effect.
The list under Conditional Formating 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.
20 Premium Edition-VII

