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.

New to Excel? Watch our Free Excel for Beginners Playlist on YouTube to get started with step-by-step video tutorials.

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 formatting 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 highlighted in green and is double underline.

Output:

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.

Chandraish Sinha

Chandraish Sinha is the Founder and President of Ohio Computer Academy, a leading institution committed to delivering high-quality IT education. With a passion for teaching and a belief in his company’s mission—Inspire, Educate & Evolve—Chandraish brings over 25 years of experience in the Information Technology industry.

Explore more of his work on his Amazon Author Profile.