Formatting Sheets Conditionally
There is an Excel file that teaches how to perform the Formatting Sheets Conditionally operation.
Excel Dashboard for Formatting Sheets Conditionally
This workbook demonstrates formatting sheets conditionally using VBA macros on a 7-row data layout.
Hope it is useful.