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!