Page 42 - Computer Genius Class 07
P. 42
4 Enter the value.
5 Click on the OK button.
This list shows various criteria like:
Highlight Cells Rules: This option is selected when you want to highlight all cells satisfying a
gi en condition. hen you ho er mouse o er this option it opens a su list sho ing criteria li e
reater Than ess Than ual To et een etc.
Top/Bottom Rules: This option is selected when you want to highlight some top or bottom number
o items in a data series. hen you ho er mouse o er this option it opens a su list sho ing
criteria li e Top 1 tems Top 1 ottom 1 tems ottom 1 etc.
Data Bars: This option is selected when you want to add data bars to the cells having numeric
data. hen you ho er mouse o er this option it opens a su list sho ing ars o di erent types
and colours that can be added to the cells.
Colour Scales: This option is selected when you want to add colour schemes to all selected cells
slo ly arying rom top to ottom items. hen you ho er mouse o er this option it opens a su
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
accepta le hich are moderate and hich need attention. The di erent types o icon sets that
can e added are sho n in the su list that opens hen the mouse is ho ered o er this option.
The selected conditional ormatting is applied to the selected cell range. ou can also define your o n
rule for highlighting cells by selecting New Rule option from the Conditional Formatting drop do n list.
The conditional formatting features applied to a data range can be cleared by selecting Clear Rules
option from the Conditional Formatting drop do n list.
40 Computer Genius-VII

