Conditional Formula based on previous date + 30
Just use CF with a formula of
=B2TODAY()
--
HTH
Bob
"Chris" wrote in message
...
I have a spread sheet that caluclates when proposals expire.
Date Sent Follow Up date
January 13, 2010 February 12, 2010
What I am looking for is for the Follow up date to turn RED when the date
is
expired (over the date listed).
|