using conditional formatting with dates
 

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?

using conditional formatting with dates
 

For your third condition you are probably using a CF formula like
this:

=cell<NOW()

You can change this to:

=AND(cell<NOW(),cell<"")

Hope this helps.

Pete

On Dec 3, 9:54*pm, Josh wrote:
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?