Hi Rachel,

You can use something like:

Rows(<number).Interior.ColorIndex = colorindex

Colorindexes are (in Europe)

''' Color index
'''--------------------------
''' Orange 46
''' Dark yellow 12
''' Red 3
''' Light orange 45
''' Lime 43
''' Aqua 42
''' Pink 7
''' Gold 44
''' Yellow 6
''' Bright green 4
''' Turquoise 8
''' Sky blue 33
''' Gray 25% 15
''' Rose 38
''' Tan 40
''' Light yellow 36
''' Light green 35
''' Light turquoise 34
''' Pale blue 37
''' Lavender 39
''' Blue-Gray 16
''' Teal 5
''' Gray 40% 48
''' Gray 25% 15

Wkr,

JP

"Rachel Costanza" <Rachel wrote in
message ...
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.