Conditions ke Basis par Formatting

1. Meaning

Conditions ke basis par formatting ka matlab hai ki Excel mein kisi cell ke value ya data ko check karke, agar woh given condition ko satisfy karta hai, to us cell par selected formatting automatically apply ho jati hai.

Simple Definition

When a cell satisfies a specified condition, Excel automatically applies the selected formatting to that cell.

2. Basic Concept

Iska basic flow hai:

DATA
  ↓
CONDITION
  ↓
EXCEL DATA KO CHECK KARTA HAI
  ↓
CONDITION SATISFY?
   ↙       ↘
 YES        NO
  ↓          ↓
FORMAT     NO CHANGE

3. Example: Marks ke Basis par Formatting

Suppose student marks hain:

Condition:

Marks < 40

Excel har mark ko check karega:

85 → False
35 → True
72 → False
28 → True

Isliye 35 aur 28 wale cells par selected formatting automatically apply hogi.

4. Condition ka Formula/Rule

Example:

Marks < 40

Yahan:

Marks
  ↓
Value being checked

<
  ↓
Condition / Comparison

40
  ↓
Limit

5. Different Conditions

Conditions data ke requirement ke according banayi ja sakti hain.

Note: Tumhare provided notes Conditional Formatting ko practical data/price/percentage exercises ke context mein cover karte hain; upar ke operators ko samajhne ke liye examples ke roop mein diya gaya hai.

6. Practical Example — Price

Suppose:

Condition:

Price > 1000

Excel check karega:

500  → False
1200 → True
750  → False
1500 → True

Therefore, 1200 and 1500 wale cells condition satisfy karte hain aur un par selected formatting apply ho sakti hai.

The provided notes specifically include practical work involving price and percentage data with Conditional Formatting.

7. Condition + Formatting

Conditional Formatting ko do parts mein samjho:

┌──────────────────┐
│    CONDITION     │
│    Marks < 40    │
└────────┬─────────┘
         ↓
┌──────────────────┐
│   DATA CHECK     │
└────────┬─────────┘
         ↓
┌──────────────────┐
│ CONDITION TRUE?  │
└───────┬──────────┘
        ↓
       YES
        ↓
┌──────────────────┐
│ APPLY FORMATTING │
└──────────────────┘

8. Important Point

Conditional Formatting mein condition data ko identify karti hai, aur formatting us identified data ko visually highlight karti hai.

For example:

Condition:
Marks < 40

        ↓

Excel checks marks

        ↓

Marks satisfying condition

        ↓

Selected formatting applied

9. Normal Formatting vs Condition-Based Formatting

10. Easy Memory Trick

Condition → Check → Format

CONDITION
   ↓
CHECK DATA
   ↓
TRUE?
 ↓      ↓
YES     NO
 ↓       ↓
FORMAT  NO CHANGE

One-line definition:

Conditions ke basis par formatting means applying formatting automatically to cells whose values satisfy a specified condition.