Okay, so the way you described it in your second post, Kwmck, you are calling 118:125 days the length of time from the original date to today, I expect.
I mocked up a simple sheet with the cells you described. In the S column I'm showing you that the formulas are that are in the R column.
I've done the date calculation below it on the sheet so you can see what I did.
Cell R23 shows the difference between the original M2 date and today in days.
The conditional formatting on cell R19 is based on what that number is.
You can do the date difference calculating right in the conditional formatting formula, but this way when you try different dates in M2 you can see the color changes, and the number of days passed at the same time.
|