Engineers-Excel.com

Conditional Formatting (Excel 2003)



This feature is useful for highlighting cells that fulfill user defined criteria. For example, if we have a list of numbers between 0 and 100 and we wish to see at a glance the numbers greater than 70, we can use this feature.

List of numbers

To do this, select the range of cells and choose Format -> Conditional Formatting. Key in the criteria and the format for the cells meeting those criteria as shown in the screen shots below.

Conditional formatting

The cells that contain numbers greater than 70 are now highlighted in yellow.

Formatted list