I am trying to conditionally format a date to change colors and can't seen to figure it out. E2 has the date of 16-Jun-14, F2 has a date of 14-May-14 (120 days from E2). 130 days out from E2, I need F2 to change to Yellow and 120 days out from E2, I need F2 to change to red. Can anyone help me with this please?
DATEDIF(start_date,end_date,unit)
Unit:
"Y" The number of complete years in the period.
"M" The number of complete months in the period.
"D" The number of days in the period.
So:
CF:
=DATEDIF(F2,E2,"D")>120 (?)
Ben Van Johnson
I am guessing I did something wrong since it didn't work for me. Attached is an example of the spreadsheet that I am working on. So on this one B2:B17 needs to change to red 90 days out and yellow 100 days out based of the date in A2:17.
Hi CrazyEyes,
Try below code, it could help you.... hope so....!
Note : add this code in sheet1
Please Login or Register to view this content.
I am not familiar with code. How does this work? Is the best way to get the dates to change color?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks