Hi,

I need help writing a macro. Column D is filled with various dates. D2 might be 2, D3 might be 55, etc. Also, the number of rows is unknown and may be as large as a thousand or more. There also might be blank cells in the column too.

I need a macro that will go through Column D and change the Fill Color based on criteria:

- If the count in the cell is less than 25, the cell's fill color should change to red

- If the count in the cell is the same or more than 25, the cell's fill color should change to green

Thanks!