using conditional formatting with dates

[Josh]

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?

 

[Pete_UK]

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