Conditional formatting by date

  wiznyme 11:14 24 Mar 2006

I'm sure this will have been answered before but I can't find it.

How do you conditionally format a cell containing dates to change colour if it's more than a specific amount of day's in the past.

Thanks for the help.


  johnnyrocker 11:43 24 Mar 2006

the 'if' function should solve this for you.


  VoG II 11:51 24 Mar 2006

Something like

=IF (TODAY() - A1) > 3

  Simsy 12:26 24 Mar 2006

Format>Conditional formatting

Cell value is "Less than" and the amount box put


where B1 is a cell that contains the number of days ago you want. You can, of course, enter this number directly, instead of via a cell.



  wiznyme 14:10 24 Mar 2006

Problem sorted.


This thread is now locked and can not be replied to.

Elsewhere on IDG sites

iMac Pro review

The City of Los Angeles graphic designer job ad amuses internet

iMac Pro review

Les meilleurs smartphones Android (2018)