Browse › Excel Expert Productivity
Use Rules to Apply Conditional Formatting
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 and configure custom formatting rules that use formulas.
- Apply a custom conditional formatting rule to highlight blank cells
- Apply a custom conditional formatting rule
- Apply a custom conditional formatting rule that uses formulas
- Use the formula to create calculations
- Modify conditional formatting
- Change the highlight color to yellow
- Remove the conditional formatting
- ⏱ About 30 minutes
- Counts towards: Microsoft Excel Expert (Microsoft 365 Apps) (exam MO-211)