🎯 What is Conditional Formatting?
✨ Conditional Formatting lets you automatically change the appearance of a cell based on its value.
It’s perfect for:
🚦 Highlighting top/bottom performers
📈 Showing trends or thresholds
✅ Quickly spotting errors or missing data
🪄 Step-by-Step Guide
✅ 1. Select Your Data Range
🖱 Click and drag to select the range you want to format
📌 Example: A1:A10 (for sales numbers)
🎨 2. Go to the Home Tab → Conditional Formatting
🔽 Click the dropdown to explore options:
Highlight Cell Rules
Top/Bottom Rules
Data Bars
Color Scales
Icon Sets
🟥 3. Highlight Cell Rules – Basic Conditions
Examples:
📊 4. Top/Bottom Rules – Ranking Made Easy
🏆 Top 10 Items → Highlight top scores
🔽 Bottom 10% → Identify weak performers
⭐ Above/Below Average → Spot trends easily
🌈 5. Data Bars – Visualize Numbers Inside Cells
Adds a progress bar in the cell, proportional to value
- 📏 Useful for comparing quantities side by side
🎨 6. Color Scales – Gradient Based on Value
- 🟢🔴 Green → Yellow → Red
Automatically color-codes low to high values
🧩 7. Icon Sets – Use Arrows, Shapes, Flags
Perfect for dashboards or financials!
🧠 8. Custom Formula – Advanced Users Only
Example:
🧮 Login to see the code → Highlight blank cells
🧮 Login to see the code → Highlight values above average
👉 Use this when built-in options don’t meet your logic needs
🔄 Remove or Manage Rules
🧹 Home → Conditional Formatting →
🧽 “Clear Rules” or
🔧 “Manage Rules” to edit
Login to see the link
Login to see the link
