I
ITGuy
I need to know how to make a block turn RED if the date exceeds a year. Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
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
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
R
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!
=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!
I
ITGuy
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.
I used =NOW()-365 and cell is less than or equal to that helped me achieve
what I wanted. Found it in another post.