View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sean Timmons Sean Timmons is offline
external usenet poster
 
Posts: 1,696
Default Conditional formatting on Date

in Conditional formatting, formula is

=cell<=now()-365

"Rick1" wrote:

I have a cell with a training date. I would like to format the cell to
change color when actual date exceeds training date by one year.