Conditional Formatting

You can use conditional formatting to highlight a cell or cells that meet certain conditions.

In the example, conditional formatting has been used to highlight the cells containing the maximum and minimum values.

Notes

The black border encloses the range called "NumRange"

The cells in that range are all conditionally formatted (From the menu: Format > Conditional Formatting...)

Below is the conditional formatting used in cell B2
 
 
In the formulas B2 is entered as a relative address

The example file (click on the link to download) demonstrates the above.

conformaxmin.zip

Published: 02-Feb-2004
Last edited: 01-Mar-2011 20:50