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

iMac Pro review

The City of Los Angeles graphic designer job ad amuses internet

iMac Pro review

Les meilleurs smartphones Android (2018)