Conditional formatting by date

  wiznyme 11:14 24 Mar 06
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 06

the 'if' function should solve this for you.


johnny.

  VoG II 11:51 24 Mar 06

Something like

=IF (TODAY() - A1) > 3

  Simsy 12:26 24 Mar 06

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 06

Problem sorted.

Jim

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

The Legend of Zelda Breath of the Wild review: Five hours with Zelda on the Nintendo Switch

1995-2015: How technology has changed the world in 20 years

How the painting-like animated sequences in A Monster Calls were created by Glassworks Barcelona

The 22 best Safari extensions | Best Safari plugins: Improve Apple's Safari web browser with these…