I need help. How do I use conditional formatting for the date in cell A1 to turn yellow when it is within a 4 years of renewal preparation and turn red when it is in a 5 years for a renewal?
Below is the formula I've used but it seem not to be working. Please help....
Use a formula to determine which cells to format
Red color
=OR( DATEVALUE(MID(A1,2,SEARCH(")",A1,2)-2)) < TODAY(), DATEVALUE(MID(A1,SEARCH("(",A1,2)+1,SEARCH(")",A1,2)-2))< TODAY() )
Use a formula to determine which cells to format
White color
put a check mark if Stop If True
=ISBLANK(A1)=TRUE
Format only cells that contain
red color
Cell value >>> greater than >>> =NOW()+1825
Format only cells that contain
Yellow color
Cell value >>> greater than >>> =NOW()+1460
Below is the formula I've used but it seem not to be working. Please help....
Use a formula to determine which cells to format
Red color
=OR( DATEVALUE(MID(A1,2,SEARCH(")",A1,2)-2)) < TODAY(), DATEVALUE(MID(A1,SEARCH("(",A1,2)+1,SEARCH(")",A1,2)-2))< TODAY() )
Use a formula to determine which cells to format
White color
put a check mark if Stop If True
=ISBLANK(A1)=TRUE
Format only cells that contain
red color
Cell value >>> greater than >>> =NOW()+1825
Format only cells that contain
Yellow color
Cell value >>> greater than >>> =NOW()+1460