Simple Conditional Formatting Chain Failure. Any Advice?

[PhilSmith-NHS]

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.

ApparelItemReviewEXAMPLE.xlsm

Anyone have any ideas?

Thanx

Phil

[#2]

@PhilSmith-NHS The link to the file requires login credentials. Please share one that gives unrestricted access.

[#3]

Sorry, saved it in the wrong folder.
https://nhs1973-my.sharepoint.com/:x:/g/personal/p_smith_nhs-inc_com/EQDchGT0vv5BpQL_3yUFyGYBtlp8vpW...

[#4 · Accepted solution]

@PhilSmith-NHS 

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.

[#5]

@PhilSmith-NHS 

Forgot the file

[#6]

I hate Mondays. Two other folks here looked that over and didn't catch it. Thank you very much!

[#7]

@PhilSmith-NHS , you are welcome