Formatting by Condition
There is an Excel file that teaches how to perform the Formatting by Condition operation.
Excel Source: Formatting By Condition
This workbook demonstrates formatting by condition using VBA macros on a 547-row data layout.
Hope it is useful.