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.
PhilSmith-NHS The link to the file requires login credentials. Please share one that gives unrestricted access.
- Sorry, saved it in the wrong folder.
https://nhs1973-my.sharepoint.com/:x:/g/personal/p_smith_nhs-inc_com/EQDchGT0vv5BpQL_3yUFyGYBtlp8vpWBKXzGDWVNgU8nBw?e=aknbGBForgot the file
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.
- I hate Mondays. Two other folks here looked that over and didn't catch it. Thank you very much!
