Progress Bar in Excel Cells Using Conditional Formatting

If you are searching for a solution or some special tricks to make a Progress Bar using Conditional Formatting in Excel cells then you have landed in the right place. Often, you may need to create a progress bar that helps to visualize the data in Excel. There is a quick and easy way to make a progress bar using Conditional formatting in Excel cells. This article will show you each and every step with proper illustrations, so you can easily apply them for your purpose. Let’s get into the main part of the article.

Steps to Create Progress Bar in Excel Cells Using Conditional Formatting

Suppose, you have a dataset containing a number of tasks in a project which is running. Another column shows the percentage completed of the task. You want to make a progress bar in this column using conditional formatting.

In this section, I will show you a quick and easy method to make a progress bar using Conditional formatting in Excel on the Windows operating system. You will find detailed explanations of methods and formulas here. I have used the Microsoft 365 version here. But you can use any other versions as of your availability. If any methods won’t work in your version then leave us a comment.

📌 Step 1: Select Progress Data and Go to Conditional Formatting Option

At first, select the cells of the Progress column.
Then go to the Home tab and select the Conditional Formatting feature.

📌 Step 2: Select More Rules from Data Bars Options

To make a progress bar, you have to select the Data Bars option in the Conditional Formatting. Follow the below steps:

After clicking on the conditional formatting, you will have more options.
Select Data Bars from them.
Select More Rules from the sub-category.

📌 Step 3: Insert Formatting Rules and Apply

Now, you will have to specify the rules to format the cells in the column. You want to apply data bars of progress which range from 0% to 100%. Follow the steps below to do this.

Now, a window named Edit Formatting Rule will appear.
Select the first one as the Rule Type.
Select the Type as Number both for Minimum and Maximum.
And, insert the value = 0 for minimum and value = 1 for maximum. As the data bar ranges from 0% to 100%

Note: You must insert 1 in the maximum value box to apply the value 100%

Then, select a color in the Bar Appearance. Also, you can see a preview
Finally, Press OK

As a result, you will see that the progress column is showing progress bars in cells.

Download Practice Workbook

You can download the practice workbook from here:

Progress Bar Using Conditional Formatting.xlsx

Conclusion

In this article, you have found how to make a progress bar using Conditional formatting in Excel cells. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.

<< Go Back to Progress Bar in Excel | Data Visualisation in Excel | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!