Question

conditional formatting order

By helenmeyer2014 ·
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)
0 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Share your knowledge
Back to Microsoft Forum
0 total posts (Page 1 of 1)  

Related Discussions

Related Forums