View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Sandy Mann Sandy Mann is offline
external usenet poster
 
Posts: 2,345
Default Formula Question

Format Conditional Formatting select Formula Is form the dropdown and
enter:

=DATEDIF($G$4,TODAY(),"m")=18

Change the $G$4 to your own reference

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"Rachel" <Rachel @discussions.microsoft.com wrote in message
...
How do I automatically get the font color to change if I have a date that
is
over 18 months old.....like I have February 1 2006 I want that to change
to
Red because it is over 18 months old.

Thanks