Can a formula change a cells colour after a given length of time?

C

Clive Humphries

Is it possible to have a cell change colour after a given time period?

i.e. change red after 30 days
 
R

Roger Govier

Hi Clive

Assuming the cell you want to highlight contains a date, (A1 in this
example) then try highlighting your cell, then
Format>Conditional Formatting>dropdown to select Formula
is>=TODAY()-A1>30
Format>Select Font, Border or Patterns and colour to your choice.

The cell(s) in question to have the formatting, do(es) not neceesarily
have to hold the date, but obvioulsy the cell used as the reference
does.

You can combine things with for example
=AND(TODAY()-A1>=30,TODAY()-A1<90)
That could be one colour, and there are 2 more formats you can add to
have different colours for different date ranges.
 
Top