Excel Conditional Formatting Practice Questions
In the previous blog, we practiced some basic questions on MS Excel formatting and filtering. In this blog, we will look at Excel conditional formatting practice questions.
if you want to practice more Excel questions, visit Excel Basics to Advanced Practice Questions.
Ques 1. Using the data set given in the previous blog, change the formatting of the values in the Profit column. Negative values should be displayed in red color and in parenthesis.
Output:
Ques 2. Using the list of numbers below, format them as phone numbers.
Output: After tformatting the above numbers, your output should appear like the one shown below.
Ques 3. Use the list courses shown below, format them so that a bullet icon appear before them.
Output: After you have completed your changes, the output should appear like the one shown below
Ques 4. Use the output of Ques 1 as the dataset for this question. Format the Sales values in such a way that Sales greater than 200 is highligted in green color and is double underline.
Output:
Ques 4. Use the same dataset as shown above. Highlighed Profit less than $10 in red color.
Output:
Ques 5. Insert two blank rows in the above data set. Create a conditonal formatting rule to highlight the blank rows in blue.
Output:
Ques 6. Use the above dataset. Create a column on the far right to Input the Category values. Start with Category = Furniture. When Furniture is entered, all the rows in the dataset pertaining to Furniture should highlight in brown. When anyother value is entered for the Category, those rows should get hightlighted.
Output: When Category Furniture is entered for Input Category
Output: When Category Office Supplies is entered for Input Category
For a step-by-step approach to learning more advanced features and functions in Excel, take a look at the book Excel Basics to Advanced.
About the Author
Chandraish Sinha has 20+ years of experience in Information Technology. He is an accomplished author and has published 11 books covering Business Intelligence related topics such as, Tableau,Power BI, and Qlik. Checkout his Amazon Author profile.
His latest book Excel Basics to Advanced covers all the aspects of MS Excel and provides exercises for self-learning.
Similarly, his recent book, Dashboarding with Tableau, covers all the features in Tableau and includes exercises for self-learning.
He has implemented IT solutions in different domains viz. Pharmaceutical, Healthcare, Telecom, Financial and Retail.
He blogs regularly on various IT topics. Check them out in the links given below:
