View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default conditional fomatting

Hi

Set the CF of A1 to
=A2=TODAY()
using the Formula Is option.

Andy.

"Jock W" wrote in message
...
If cell A2 contains todays date (using the NOW() formula) how do I get the
contents of A1 to be displayed either in bold and/or different colour?

tia

--
Jock Waddington