Conditional formatting by date

  wiznyme 11:14 24 Mar 2006
Locked

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.

Jim

  johnnyrocker 11:43 24 Mar 2006

the 'if' function should solve this for you.


johnny.

  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

=TODAY()-B1

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.

Regards,

Simsy

  wiznyme 14:10 24 Mar 2006

Problem sorted.

Jim

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

Elsewhere on IDG sites

Best phone camera 2017

Stunning new film posters by Hattie Stewart, Joe Cruz & more

iPad Pro 10.5in (2017) review

28 astuces pour profiter au mieux de votre iPhone