I have tried to format a set of data with the following rules: =AND(OR(P2="AIR";P2="SEA");W2="";M2<(TODAY()+7))
If I put it in as a normal formula, the outcome is correct. However, if I put the same formula in as a format (to color the ones that are TRUE) it will only apply to some of the cells...