Microsoft·451 discussions

conditional formatting order

Locked

Tags: Microsoft

I’m trying to apply the following formulas via conditional formatting but I don’t know which order to put them in because they keep overwriting each other and not colouring in properly. I know this is probably a silly question but its the first time i’m using conditional formatting. Any help would be appreciated.

=IF(OR(AND(b1<=TODAY()-1825,b1>1),(b1=”TBA”)),TRUE)
=IF(AND(b1<=TODAY()-1642,b1>1),TRUE)
=IF(OR(AND(b1<=TODAY()-1095,b1>1),(b1=”TBA”)),TRUE)
=IF(AND(b1<=TODAY()-**5,b1>1),TRUE)

Topic