Condition Format Formula Help

Hey all,

I am trying to conditionally format the cells in a column titled "Bid Due Date" (in table "ActiveBids"). For each cell in "Bid Due Date", it should look to the corresponding value of Y:Y (not in any table). IF Y:Y=0, then "Bid Due Date" should be GREEN, If Y:Y EQUALS 1 or 2, then "Bid Due Date" should be YELLOW. If Y:Y IS LESS THAN 1, then "Bid Due Date" should be RED.

I've attached a sample.

Take a look at these formulas

Please Login or Register  to view this content.

Thanks so much. I have to sit down one day and figure out why and how the conditional format formulas are always changing on me.