View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
nelly nelly is offline
external usenet poster
 
Posts: 31
Default 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