Browse › Excel Expert Productivity
Can You Create Custom Conditional Formatting Rules?
Part of Excel Expert Productivity Topic: Essential IT
Access
StationX Infrastructure Labs — 3 attempts per lab
🔒 Add StationX Infrastructure Labs — $149 / year · 3 attempts per lab
Already have access? Sign in.
New to this? Try a free practice lab — a scripted hacking challenge in your browser, no account needed.
What you'll do
In this lab, you will create custom conditional formatting rules.
- Apply custom conditional formatting rules that highlight cells with the highest and lowest sales figures
- Create custom conditional formatting rules that highlight cells based on specified criteria
- Use formulas to determine the highest and lowest sales figures for each product in each region
- ⏱ About 45 minutes
- Counts towards: Microsoft Excel Expert (Microsoft 365 Apps) (exam MO-211)