conditional formatting with dates

F

Frank stone

Hi,
try this:
condition 1
cell value is between =Today()+30 and =today()-30
text font = green
conditin 2
cell vaue is < =Today()-30
text font = red
I tried on this dates
7/15/04 =red
8/26/04 = green
9/30/04 = black
:)
 
B

Brian

Thanks

Frank stone said:
Hi,
try this:
condition 1
cell value is between =Today()+30 and =today()-30
text font = green
conditin 2
cell vaue is < =Today()-30
text font = red
I tried on this dates
7/15/04 =red
8/26/04 = green
9/30/04 = black
:)
Click to expand...
 
Top