Explanation

Conditional Formatting automatically changes the appearance of cells when they meet specific conditions.

Common Uses

  • Highlight values greater than ₹50,000
  • Identify duplicate values
  • Highlight overdue dates
  • Show top/bottom values
  • Data Bars
  • Color Scales
  • Icon Sets

Example

Highlight sales greater than ₹50,000:

Home → Conditional Formatting → Highlight Cells Rules → Greater Than

Practice

Apply:

  1. Green highlight for Sales > ₹50,000
  2. Red highlight for Sales < ₹10,000
  3. Data Bars for Sales
  4. Color Scale for Profit
PreviousNext