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.
📌 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 Circle Chart in Excel as Never Seen Before
- How to Make a Progress Monitoring Chart in Excel (with Easy Steps)
- Excel To Do List with Progress Tracker (4 Suitable Examples)
📌 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.
📌 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%
- 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.
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.