Formatting Table Conditionally
There is an Excel file that teaches how to perform the Formatting Table Conditionally operation.
Excel Powered Formatting Table Conditionally
This workbook demonstrates formatting table conditionally using VBA macros on a 60-row data layout.
Hope it is useful.