Quote Originally Posted by NBVC
You don't need a macro for that.. you can use built in Conditional Formatting

Select entire column D and go to Format|Conditional Formatting

Cell Value Is >> Greater than or equal to >> enter: =25

click Format and go to Pattern tab to choose your colour (green)

Click Ok.

Click Add

Cell Value is >> Greater than >> enter: =0

Click Format and choose colour (red)

Click Ok

Click Ok to finish.
Okay, and what if I wanted the column beside the count to say:

"low" if the count in the cell is less than 25, the cell's fill color should change to red

"high" if the count in the cell is the same or more than 25, the cell's fill color should change to green

P.S. you're an excel genius lol