Thread
:
Formula Question
View Single Post
#
2
Posted to microsoft.public.excel.misc
Sandy Mann
external usenet poster
Posts: 2,345
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
Reply With Quote
Sandy Mann
View Public Profile
Find all posts by Sandy Mann