macro: changing cell color based on count in cell

Originally Posted by NBVC

you would enter a formula in the cell.

e.g. =if(d1<25,"low","high")

if you want those cells coloured too, then select that column and invoke the Conditional Formatting...

Cell Value Is >> equal to >> enter: ="low"

choose red format..

Click Add

Cell Value Is>> equal to >> enter: ="high"

Choose green format

You're a genius, thanks a bundle.