Peter
When do you want this, the coloring of rows, to happen? When you enter
a number in one of those cells? When you save the file? Close the file?
You say the numbers are in "column O, P". That's two columns. Did you mean
to say both columns? If so, can numbers be entered into both columns? If
so, and the two numbers conflict (two different colors), what do you want to
happen? In what row does your data start? HTH Otto
<peter brink wrote in message
...
Does anyone know how to use this macro and add lines of data. i can only
get this macro to work on 23 rows but I need a few more.

Thanks



Posted as a reply to:

Macro for HEAT chart - THANKS IN ADVANCE!

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.

EggHeadCafe - Software Developer Portal of Choice
WCF Workflow Services Using External Data Exchange
http://www.eggheadcafe.com/tutorials...vices-usi.aspx