Flag a Row When Any One Condition Is True

Excel & Google Sheets

How it works

OR takes any number of tests and returns TRUE the moment one of them passes — Rush shipping, a value over 500, or both. IF then converts that into Escalate or Normal. Only when every test fails does the row stay Normal. Note the text comparison isn't case-sensitive, so "rush" and "RUSH" in column A both match. And B2>500 is strict: an order of exactly 500 stays Normal, because 500 is not greater than 500 — use >= if the threshold itself should escalate.

A2="Rush"

First trigger: the shipping method is Rush (any capitalization).

B2>500

Second trigger: order value strictly above 500 — exactly 500 doesn't fire.

OR(…)

TRUE when at least one trigger passes; FALSE only when all fail.

When to use it

Use it wherever one match is enough: escalate tickets that are urgent or aging, review expenses that are large or missing a receipt, flag shipments that are late or incomplete.

Common mistakes

• ✕Using AND when the rule says either.

  ✓AND(A2="Rush",B2>500) escalates only orders that are both Rush and large — a $900 ground order slips through. "Either one" means OR.

• ✕The threshold row doesn't escalate.

  ✓B2>500 excludes exactly 500. If a $500 order should count, write B2>=500 — one character changes the policy.

• ✕Writing OR(A2="Rush","Express") to match two methods.

  ✓Each test must be complete on its own: OR(A2="Rush",A2="Express"). A bare "Express" isn't a condition and won't match anything.