If you are using Microsoft Excel the correct answer is conditional formatting.
Conditional Formatting allows you to format data based on a variety of conditions. For example, you can format your data so that numbers less than a specified value appear a specific color,
