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?
|