past cell by date

[Tony]

ok thanks for my last post
what if i want to put a date in colum 1 and when its the value in column 2
past ie 36 months past that date i want the date cell to turn red
Thanks Tony

 

[Pete_UK]

Use Format | Conditonal Formatting with a formula of:

=A1>B1+3*365

assuming that the cell you want to change is A1.

Hope this helps.

Pete

 

[Mike H]

Tony,

What you are wanting to do is achievable with conditional formatting but I
don't understand what you mean. For the 2 cell values (dates) to move apart
one must be a function =today() and one a fixed date, which is which and
which column do you want highlighted?

Mike