In Excel, conditional formatting allows you to set up rules to format cells based on a set of criteria.
For example, let’s say you want to quickly figure out how well students are doing in a class. In the example below, using conditional formatting, the students who score 90% or higher are highlighted in green; the students who score between 80 and 89% are highlighted in yellow; the students who score less than 80% are highlighted in red.
In Excel 2003 and earlier, to use conditional formatting, select the cell, and then on the Format menu, select Conditional Formatting, and then set the conditions.
In Excel 2007 and newer, select the cell, and then on the Home tab, click Conditional Formatting and then click Manage Rules. Then, set the conditions.
Without Conditional Formatting:
With Conditional Formatting: