I have a spreadsheet using excel 2003. I need the row to be one color if a
box is filled in with specific text. I have that. I now have 2 conditions
left to use. I need the row to turn one color when the date in the box is
between now and 30 days from now. Then I need it to turn another color when
that same date in the box is past. I think i have the coloring down but my
blank cells change color. is there any way to avoid this?