Adding Conditional Formatting
There is an Excel file that teaches how to perform the Adding Conditional Formatting operation.
Excel Professional Adding Conditional Formatting
This workbook demonstrates adding conditional formatting using VBA macros on a 21-row data layout.
Hope it is useful.