Progress Bar in Excel Cells Using Conditional Formatting

If you are searching for the 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.


Download Practice Workbook

You can download the practice workbook from here:


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. And another column is showing the percentage completed of the task. You want to make this column a progress bar 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 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.

Progress Bar in Excel Cells Using Conditional Formatting


πŸ“Œ Step 1: Select Progress Data and Go to Conditional Formatting Option

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

Progress Bar in Excel Cells Using Conditional Formatting

Read More: How to Make Progress Chart in Excel (2 Simple Methods)


Similar Readings


πŸ“Œ 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 more options.
  • Select Data Bars from them.
  • And select More Rules from the sub-category.

Select More Rules from Data Bars Options

Read More: How to Create Progress Bar Based on Another Cell in Excel (2 Easy Ways)


πŸ“Œ 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 ranges 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

Insert Formatting Rules

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

Progress Bar in Excel Cells Using Conditional Formatting


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. You can visit our website ExcelDemy to learn more Excel-related content. Please, drop comments, suggestions, or queries if you have any in the comment section below.


Related Articles

Osman Goni Ridwan

Osman Goni Ridwan

I am Ridwan, graduated from Naval Architecture and Marine Engineering Dept, BUET, currently residing in Dhaka, Bangladesh. And my passion is to grow up my skillsets with industry demands. My prime goal is to be a data analyst as I do love to solve problems and play with data.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo