Coloring Based on Value
There is an Excel file that teaches how to perform the Coloring Based on Value operation.
Excel Powered Coloring Based On Value
This workbook demonstrates coloring based on value using VBA macros on a 10-row data layout.
Hope it is useful.