Conditional Formatting

[Guest]

I need to know how to make a block turn RED if the date exceeds a year. Thanks!

 

[Jason Morin]

Do you mean if the data exceeds one year from today? If
so, select the target cell, go to Format > Conditional
Formatting, choose Formula Is, and put:

=$A$1<DATE(YEAR(TODAY())-1,MONTH(TODAY()),DAY(TODAY()))

Change $A$1 to your actual cell reference.

HTH
Jason
Atlanta, GA

 

[RagDyeR]

Try this in - Conditional Format - Formula Is:

=DATE(YEAR(E1)+1,MONTH(E1),DAY(E1))<=TODAY()

If E1 was your cell to format.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


I need to know how to make a block turn RED if the date exceeds a year.
Thanks!

 

[Guest]

Thanks all,

I used =NOW()-365 and cell is less than or equal to that helped me achieve
what I wanted. Found it in another post.