Originally Posted by kilroyscarnival

Hi, it looks like you have the conditional formatting for the yellow (less than or equal to 118 days' difference between original date and today) and the red (greater than 126 days' difference between those dates.) Note that I used greater than or equal to 117 days, not 118, because I presumed your third category would cover 118 days in the green condition.

Where I appear to have messed up is I also have overlapping conditional formats on 126 days. The red formula should have > 126, not >= 126. So if it's exactly 126 days it still falls in the green, if I understood what you wanted.

All you really have to do is emulate the formula I had for the green condition, which in the case of this new file would be