- Macro for coloring cells according to the value of the cell!
- Excel macro color cell based on value ✓ - Forum - Programming
- Run macro automatically when cell value changes ✓ - Forum - Excel
- Excel count conditional formatting color cells - Forum - Excel
- Run a macro when a cell value changes - How-To - Excel
- Excel macro to merge cells based on condition ✓ - Forum - Excel
It is called Conditional Formatting, take a look here: