highlight font by date
You can use conditional formatting and set the "formula" option to something
like this (where the value is in E12)
=E12(TODAY()-3)
Tim
"Nelly" wrote in message
...
-Hello,
Is there a way to highlight font and type for a cell by a date criteria?
For
instance, if a date is within 3 days of the current system date I want the
date bolded in red 14pt font. I also want to use green and yellow colors
to
indicate other proximities of date to current system date. I think I might
be
able to use conditional formatting for this but not sure how.
Thanks,
Nelly
|