Automatically format cells (e.g. change font color) based on a certain condition? Use the conditional Formatting. Conditional formatting allows you to set rules for cell formatting. If the rules (conditions) are met, then the formatting is applied. To do this:
1. Select the cells to be formatted
2. On the [Home] tab of the ribbon click [Conditional Formatting]
3. Leave the first drop-down box set to ‘Cell Value Is’
4. In the second drop-down box, choose one of the operators. Example, choose ‘greater than’
5. In the text box, type a number or a cell reference. In this example, type the value you want to check – 499999.
6. Click the Format button
7. On the Patterns tab, select a colour for the conditional formatting — blue, in this example.
You can also choose a Font format or a cell Border.
8. Click OK.
9. To add another conditional format, click the Add button.
10. Repeat steps 3 to 8, using the values and colours for the second conditional format.
11. Click OK, to return to the worksheet.