- Macro for coloring cells according to the value of the cell!
- Run macro when cell value changes - Guide
- Excel macro to create new sheet based on value in cells - Guide
- Excel conditional formatting if another cell contains specific text ✓ - Excel Forum
- If cell contains date then return value ✓ - Office Software Forum
- How would you change all cells containing the word pass to green - Excel Forum
It is called Conditional Formatting, take a look here: