Home>Blogs>Excel Tips and Tricks>Progress Bar in Excel Cells using Conditional Formatting
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:

Meet PK, the founder of PK-AnExcelExpert.com! With over 15 years of experience in Data Visualization, Excel Automation, and dashboard creation. PK is a Microsoft Certified Professional who has a passion for all things in Excel. PK loves to explore new and innovative ways to use Excel and is always eager to share his knowledge with others. With an eye for detail and a commitment to excellence, PK has become a go-to expert in the world of Excel. Whether you're looking to create stunning visualizations or streamline your workflow with automation, PK has the skills and expertise to help you succeed. Join the many satisfied clients who have benefited from PK's services and see how he can take your Excel skills to the next level!