Explanation

Advanced Conditional Formatting allows you to create rules using formulas.

Example

Highlight complete rows where Sales are greater than ₹50,000:

=$H2>50000

Highlight duplicate Order IDs:

=COUNTIF($A$2:$A$100,A2)>1

Highlight blank Customer names:

=$C2=””

Practice

Create formula-based rules to identify:

  • Duplicate orders
  • Missing customer names
  • High-value sales
  • Low-stock products
  • Overdue payments
PreviousNext