Conditional Formatting & Data Validation
Conditional Formatting useful patterns ko visually highlight karta hai, aur Data Validation invalid ya inconsistent entry ko control karne me help karta hai.
Conditional Formatting
Rule ke basis par cells ka visual format automatically change ho sakta hai. Example marks above 80 highlight karna ya duplicate values identify karna.
Useful rule examples
- Greater Than / Less Than
- Duplicate Values
- Top/Bottom values
- Data Bars
- Color Scales
- Formula-based rules
Conditional formatting ka goal important pattern quickly dikhana hai. Har cell ko rainbow banana analysis ko better nahi karta.
Data Validation
Data Validation se allowed input define kar sakte ho. Example marks 0–100 ke beech, ya Department ke liye dropdown list.
Dropdown lists
Repeated categories ke liye dropdown spelling variations reduce kar sakta hai. Sales, sales, Sale jaisi inconsistency reporting ko difficult bana sakti hai.
Validation is not security
Practical scenario
Student marks sheet me 0–100 validation lagao, marks above 80 highlight karo, aur Result column ke liye later IF formula use karo.
Practice — Data quality
- Marks column me 0–100 validation set karo.
- 80 se above values highlight karo.
- Department column ke liye dropdown banao.
- Duplicate IDs ko highlight karke inspect karo.
Interactive formatting/data-validation support Excel Lab ke next phase me add kiya jayega.