Color-Code Your Excel Data
Make your data easier to read by color-coding it.
To make your data easier to read, color-code it with the Conditional Formatting feature. Select the desired cells, then choose Conditional Formatting from the Format menu. In the first field of the dialog box, choose which value you want to base the condition on (for example, Cell or Formula). In the second field, select the terms (for example, Between or Greater Than Or Equal To). In the third and fourth fields, choose the desired numerical range. To specify the cell's appearance, select the Format menu, then experiment with font, border and pattern (which includes color). Click on OK to complete the first condition, then repeat the process to add more conditions.