Question

  • Creator
    Topic
  • #2144301

    conditional formatting order

    Locked

    by helenmeyer2014 ·

    Tags: 

    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)

All Answers

Share your knowledge