How to create Progress Bar in Excel, conditional progress bar

Progress Bar is a visual tool that shows the progress of work, allowing users to easily track data changes. How to create a Progress Bar in Excel not only makes the spreadsheet more vivid and easier to understand, but is also a useful tool for those who often write reports, helping to present information clearly and intuitively.

Creating a Progress Bar in Excel is not difficult, this tool is extremely simple but very useful in Excel and is used for many different purposes. With how to create a Progress Bar in Excel in this article, users will learn about one more feature in thousands of features that spreadsheets can make your work better.

How to create Progress Bar in Excel, conditional progress bar Picture 1 How to create Progress Bar in Excel, conditional progress bar Picture 1 Instructions for creating a Progress Bar in Excel

1. How to create Progress Bar in Excel 2019, 2016, 2013

Because Excel 2019, 2016 and 2013 versions have the same interface, here TipsMake will guide you to create Progress Bar in Excel on Excel 2016. Excel 2019 and Excel 2013 users can do the same.
==> Excel 2019 download link here ==> Excel 2016 download
link here ==> Excel 2013 download link here

How to create Progress Bar in Excel, conditional progress bar Picture 2 How to create Progress Bar in Excel, conditional progress bar Picture 2

Step 1: On the Excel interface, go to Home > select Conditional Formatting > select Data Bars and select More Rules .
- Note that you must click on the cell where you want to create a Progress Bar in Excel first.

How to create Progress Bar in Excel, conditional progress bar Picture 3 How to create Progress Bar in Excel, conditional progress bar Picture 3

Step 2: In the New Formatting Rule section , select the following:

How to create Progress Bar in Excel, conditional progress bar Picture 4 How to create Progress Bar in Excel, conditional progress bar Picture 4

- Select a Rule Type : Select Format all cells based on their values.
- Edit the Rule Descripton : Here you set the Type to Number with Value Minimum as 1 and Maximum as 100. (Minimum is the minimum value of the number you enter and Maximum is the maximum, the system will base on that to display the Progress Bar).
- Bar Appearance : This part is up to you, you can choose the most pleasant color and then click OK.

Step 3: The first result is 95 corresponding to the displayed Progress Bar color column, now do the same for the remaining addresses.

How to create Progress Bar in Excel, conditional progress bar Picture 5 How to create Progress Bar in Excel, conditional progress bar Picture 5

- You will see each cell value colored corresponding to the number we have specified (the highest is 100), that is how the Progress Bar is displayed.

How to create Progress Bar in Excel, conditional progress bar Picture 6 How to create Progress Bar in Excel, conditional progress bar Picture 6

- Just change the values, the Progress Bars will also change accordingly, so we have completed how to create Progress Bar in Excel 2019, 2016 and Excel 2013.

How to create Progress Bar in Excel, conditional progress bar Picture 7 How to create Progress Bar in Excel, conditional progress bar Picture 7

2. How to create Progress Bar in Excel 2010, 2007

Similarly, now let's create a Progress Bar in Excel with the same example on Excel 2010, 2007.
==> Link to download Excel 2010 here
==> Link to download Excel 2007 here

How to create Progress Bar in Excel, conditional progress bar Picture 8

Step 1: Open the Excel file, look at Home > select Conditional Formatting > select Data Bars and select More Rules .
- Note that you must click on the cell where you want to create a Progress Bar in Excel first.

How to create Progress Bar in Excel, conditional progress bar Picture 9 How to create Progress Bar in Excel, conditional progress bar Picture 9

Step 2: In the New Formatting Rule section , select as in the instructions for creating a Progress Bar in Excel 2016, 2013 to create a Progress Bar in Excel:

How to create Progress Bar in Excel, conditional progress bar Picture 10 How to create Progress Bar in Excel, conditional progress bar Picture 10

Step 3: The first result is 75 corresponding to the displayed Progress Bar color column, now repeat for all the above results.

How to create Progress Bar in Excel, conditional progress bar Picture 11 How to create Progress Bar in Excel, conditional progress bar Picture 11

You will see each cell value is colored corresponding to the number we have specified (the highest is 100), that is how the Progress Bar is displayed.

How to create Progress Bar in Excel, conditional progress bar Picture 12 How to create Progress Bar in Excel, conditional progress bar Picture 12

So we have completed creating Progress Bar in Excel. Very simple and easy to do within 1 minute, right? Above are instructions on how to create Progress Bar in Excel 2019, 2016, 2013, 2010, 2007 by TipsMake. With the above instructions, creating Progress Bar will become simple and especially for new Excel users, this is a trick that cannot be ignored.

Above are instructions on how to create a Progress Bar in Excel 2016, 2013, 2010, 2007 from TipsMake. With the above instructions, creating a Progress Bar will become simple and especially for new Excel users, this is a trick that cannot be ignored.

In addition, when using Excel, don't forget to quickly familiarize yourself with Excel shortcuts and how to line break in Excel. They will determine part of your operations as well as speed up your work progress.