Coloring Formula Conditionally
There is an Excel file that teaches how to perform the Coloring Formula Conditionally operation.
Excel Professional Coloring Formula Conditionally
This workbook demonstrates coloring formula conditionally using VBA macros on a 20-row data layout.
Hope it is useful.