Forum Discussion
Solved
Simple Conditional Formatting Chain Failure. Any Advice?
I have three rules. 1) C2<B2 2) C2 >A2 3) C2<A2. It does not matter what order they are in, (they should be as above,) and whether the stop flag is set. (they should be set) Only 3) w...
Rules formula are wrong
Correct first two and it works. Stop if True is not required in this case, on the same cell conditional formatting works till first rule which returns true.
Sorry, saved it in the wrong folder.
https://nhs1973-my.sharepoint.com/:x:/g/personal/p_smith_nhs-inc_com/EQDchGT0vv5BpQL_3yUFyGYBtlp8vpWBKXzGDWVNgU8nBw?e=aknbGB
https://nhs1973-my.sharepoint.com/:x:/g/personal/p_smith_nhs-inc_com/EQDchGT0vv5BpQL_3yUFyGYBtlp8vpWBKXzGDWVNgU8nBw?e=aknbGB
Rules formula are wrong
Correct first two and it works. Stop if True is not required in this case, on the same cell conditional formatting works till first rule which returns true.