I am having trouble with my DB and setting up Conditional Formatting. I have a Date field where there are 4 possible conditions. No Date, Past Date, Future Date within 30 Days, Future Date >30 days. I have set up the conditions, but do not see all of them in action. All 4 conditions have different color fills set up. The No Date, Past Date, and Future w/i 30 show the same color fill. Only the Future beyond 30 has a different color. It seems pretty straight forward to me, yet still eludes.

The problem is probably the order of the conditions. Unlike a Case statement, a conditional format will go through all the conditions every time, and therefore only display the last true condition.

The attachment shows the order that ensures that the correct condition is applied.