Introduction to Microsoft Excel
0/3
Data Entry and Formatting
0/4
Formulas and Basic Functions
0/4
Logical Functions
0/3
Date, Time, and Lookup Functions
0/4
Data Management Tools
0/4
Excel Tables and Pivot Tables
0/5
Charts and Data Visualization
0/6
Advanced Excel Features
0/5
Automation, Dashboards, and Projects
Conditional Formatting
Conditional Formatting is an Excel feature that automatically changes the appearance of cells based on specified conditions. It helps users quickly identify important data, trends, and values.
Benefits of Conditional Formatting
- Highlights important values.
- Identifies high and low numbers.
- Shows trends visually.
- Makes reports easier to analyze.
Location
Home Tab → Styles Group → Conditional Formatting
Common Conditional Formatting Rules
| Rule Type | Purpose |
|---|---|
| Greater Than | Highlights values greater than a specified number. |
| Less Than | Highlights values below a specified number. |
| Between | Highlights values within a range. |
| Duplicate Values | Finds duplicate entries. |
Example
Highlight all student marks greater than 80 using a green fill color.
| Student | Marks |
|---|---|
| Rahul | 85 |
| Priya | 65 |
ShortcutFunctionAlt + H + L Open Conditional Formatting Menu
