past cell by date
 

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

past cell by date
 

Use Format | Conditonal Formatting with a formula of:

=A1B1+3*365

assuming that the cell you want to change is A1.

Hope this helps.

Pete

On Jul 18, 7:01*pm, "Tony" wrote:
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

past cell by date
 

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

"Tony" wrote:

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