Excel MarkBook
Conditional Formatting
1
To use conditional formatting select a cell or group
of cells. To select a entire column click on
the letter of the corresponding column. To select
a row click on the number of the column.
2 Select
Format | Conditional Formatting...
Theory:
Conditional formatting applies a format, such as cell shading or font colour, automatically to cells if a specified condition is true. Up to three conditional formatting rules can be applied to any cell or group of cells.
Conditional formats are useful if you want to highlight cells with a particular value or range of values.
