View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Bob Phillips[_4_] Bob Phillips[_4_] is offline
external usenet poster
 
Posts: 834
Default 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).