On Aug 18, 7:17 pm, Rachel Costanza <Rachel
wrote:
I am trying to create a macro that will color code the rows in a spreadsheet.

The days for reference are in column O,P.

For days between 1-30 i need the rows to turn green
For days between 31-60 i need the rows to turn yellow
For days between 61-90 i need the rows to turn orange
For days between 91-700 i need the rows to turn red.

Thanks in advance for your time.

Hi Rachel,
an interesting article on heat maps is
http://www.clearlyandsimply.com/clea...eat-a-map.html

Hope that helps; have fun
Cheers
Michael