This should be easy but I am about to lose my mind. I have rows of data and need the rows highlighted when they are over 60 days out, 60 - 31 days, and 30 or less. I broke it down 100 ways from Sunday watching different youtube videos and looking at different forum posts.

So basically what I have set up are three columns. Expiration date, 60 days, and 30 days. The last two give me TRUE or FALSE.
Capture.JPG

If I get FALSE to 60 AND FALSE to 30, then it gets highlight Green
If I get TRUE to 60 AND FALSE to 30, then it gets highlight Yellow
If I get TRUE to 60 AND TRUE to 30, then it gets highlight Red

But all I get is green

Here are visuals to formulas:
_order.JPG
_green.JPG
_yellew.JPG
_red.JPG

Any idea on what I am missing here?