Progress Bar in Excel cell
Excel Tips and Tricks

Progress Bar in Excel Cells using Conditional Formatting

In this article, you will learn how to display the Progress Bar in Excel Cells. We have used Conditional Formatting Data Bar to create this. Progress Bar will be filled according to the value entered in the cell.

Below are the steps to create Progress Bar in Excel Cells-

  • Select the range for your completion percentage.
  • Go to Home >> Conditional Formatting >> New Rule
  • Select Format all cells based on their values (1st Option)
  • Select the Format Type as Data bar
  • Take Minimum and Maximum Type as Number
  • Put Minimum Value 0 and Maximum Value 1
  • Select the color and click on OK
Data Bar Conditional Formatting
Data Bar Conditional Formatting

 

After putting the Data Bar our excel cells will look line below image-

Progress Bar in Excel cell
Progress Bar in Excel cell

Click here to download this practice file-

Watch the step by step video tutorial:

PK
My Name is PK. I am founder of PK-AnExcelExpert.com. I am a Microsoft Certified Professional. I have more than 10 years of experience in Data Visualization, Excel Automation and dashboard creation. Excel is my passion and I like to do always something innovative in Excel and share it with other people.
https://www.pk-anexcelexpert.com