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) works. The other two are ignored.
CLUE? One thing I noticed: I deleted a lot of columns to create the simple example I can share below. The formula for 3) changed to reflect the new column positions. The other two did NOT change. I fixed those two manually, but it did not change the results.
Anyone have any ideas?
Thanx
Phil
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
