conditinal formatting multiple not and single and

[tagteam]

I am looking for a way to use conditional formatting that will allow me to use conditional formatting but not on select criteria.

I have tried

[BillingInvoicingParty]<>"BNSF" OR [BillingInvoicingParty]<>"CSXT" OR [BillingInvoicingParty]<>"NS" Or [BillingInvoicingParty]<>"UP" And [SumofNetCharge]>15000 And I set that to make them Red.

What that should is highlight any line where the BillingInvoicingParty is not BNSF or CSXT or UP or UP but is still over 15,000

instead it makes them all highlighted

[JoeM]

Because you are checking for the value NOT to be one of those options, you need to switch all of those ORs to ANDs, i.e.

[BillingInvoicingParty]<>"BNSF" AND [BillingInvoicingParty]<>"CSXT" AND [BillingInvoicingParty]<>"NS" AND [BillingInvoicingParty]<>"UP" And [SumofNetCharge]>15000

[June7]

Grammatically, if it helps to understand the logic, the correct structure is:

not BNSF nor CSXT nor NS nor UP

in other words,

not BNSF and not CSXT and not NS and not UP