highlight font by date
-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
|