Question 1 of 10
Download Starbucks Location Data to get started.
Select column B and click Conditional Formatting in the Home tab of the ribbon. Hover over Highlight Cell Rules and click Greater Than. Enter 1000 into the box and click ok. How many countries have over 1,000 Starbucks locations?
Conditional Formatting - Free Excel Practice Online
This free, interactive exercise teaches you Conditional Formatting in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the Other Excel Skills track and works right in your browser - no Excel install, no download, and no signup.
Practising Conditional Formatting this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this Conditional Formatting lesson
- Conditional formatting highlights all the cells which meet a specified rule.Download Starbucks Location Data to get started.Select column B and click Conditional Formatting in the Home tab of the ribbon. Hover over Highlight Cell Rules and click Greater Than. Enter 1000 into the box and click ok. How many countries have over 1,000 Starbucks locations?
- Now click Conditional Formatting, hover over Clear Rules, and click Clear Rules from Entire Sheet. This removes all conditional formatting from the worksheet. How many cells are pink now?
- Now select column B and click Conditional Formatting > Highlight Cell Rules > Less Than. Enter 3 into the box and click ok. How many countries in the list have less than 3 locations?
- Clear rules from the sheet and select column B again. Go to Conditional Formatting > Highlight Cell Rules > Between. Enter 45 and 50 in the boxes and click ok. Which country has between 45 and 50 locations?
- Clear rules from the sheet again. Now highlight column B and go to Conditional Formatting > Highlight Cell Rules > Equal To and enter 14. Enter one of the countries with 14 locations.
- Clear rules from the sheet again. This time, select column A. Go to Conditional Formatting > Highlight Cell Rules > Text That Contains. Enter hi into the box and click ok. How many country names contain "hi"?
- Clear rules from the sheet again. Select column B and go to Conditional Formatting > Highlight Cell Rules > Duplicate Values. Duplicate values will turn pink. Is Denmark's location count a duplicate value? Yes or no?
- Is Egypt's location count a duplicate value? Yes or no?
- Clear rules and select column A. Create a highlight rule for text that contains ex. How many country names include "ex"?
- Clear rules and select column B. Create a highlight rule for locations over 800. How many countries have over 800 Starbucks locations?
Conditional Formatting practice - FAQ
How do I practice Conditional Formatting in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the Conditional Formatting exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this Conditional Formatting lesson?
This lesson covers Conditional Formatting as part of the Other Excel Skills track. You practice the syntax step by step until it becomes muscle memory you can use at work.