I am trying to use conditional formatting to show when a date is less
than 30
days in the future. When I use "cell value" "is less than" "="Now()+30"
all
the dates change.
lose the quotes in the condition =Now()+30
Unless you mean between today and 30 days in the future in which case
=now() would be the first condition and =now()+30 would be the second
Also now() returns the date and time is this what you require often
today() which just returns the date is preferable
Regards
Dav
--
Dav
------------------------------------------------------------------------
Dav's Profile:
http://www.excelforum.com/member.php...o&userid=27107
View this thread:
http://www.excelforum.com/showthread...hreadid=513696