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

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

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

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!
==============================================


"ITGuy" wrote in message
...
I need to know how to make a block turn RED if the date exceeds a year.
Thanks!

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.

"RagDyeR" wrote:

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!
==============================================


"ITGuy" wrote in message
...
I need to know how to make a block turn RED if the date exceeds a year.
Thanks!