Use Conditional Formatting in Excel
Conditional Formatting is a tool that allows you to apply formats to a cell or range of cells, and have that formatting change depending on the value of the cell or the value of a formula.
Step by step instructions & practice workbook