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