How to Create Progress Bars in MS Excel with Conditional Formatting

In this video, we’ll be showing you how to create progress bars in Microsoft Excel with Conditional Formatting.

Progress bars show you visually how close you are to a goal. It can seem confusing at first, but once you know how, you’ll be able to easily make progress bars! Let’s create a progress bar in this document.

1. This is our current amount, and this is our goal which will be 100% on the progress bar.
2. Click in the cell you want the progress bar to be. It is recommended to increase its size.
3. Click Conditional Formatting at the top, Data Bars, then More Rules.
4. Change the color to your liking.
5. Change Minimum to Number and Maximum to Number as well. Change the value of the Maximum to 1 and hit OK.
6. If we type 35 in here, you can see that the progress bar shows up, but it is filled. To fix this, click the Percentage button at the top and reinput the number. Now it works as expected.
7. Finally, let’s make a formula here instead of inputting it manually. Type =D5/D6.
8. Now when we edit our original values, the progress bar updates accordingly.

Conditional Formatting may seem confusing, but we only went through a few short steps to make a progress bar.

❓💬 What else would you like to learn about Conditional Formatting? Let us know in the comments below.

#HowTech #Excel
--------------------------------------------------------------------------------------------------------------

[Leruiz_]

INCREDIBLE! I solved a 20 minute problem I had in just 2 minutes with your video, thank you!

[eneadastavri]

I was looking for this formula to create a progress bar. Thank very much for sharing. :)

[adamulias]

This video is EXCELLENT!!! Thank you so much for making it! 😃👍

[cogwheelLearning]

It is so toughtful of you to share so much information for free ❤️

[arjunaromantis]

thank you..useful and simple..good job👍

[infinitegods]

Great vid. Just what I was looking for. How do you make the bar veritcal within a cell?

[jaclee]

Thanks a lot for this useful video in a neat and efficient way. Can the Progress Bar be added with drop down list with a set of predefined %, e.g. 0, 25%, 50%, etc. instead of pulling the data from another cell? Thank you.

[pelusomex]

what about a combination of two conditional? let's say...if your number is higher than 75 is greeen, below that is yellow...

[willilawson]

missing something here ... where did you select the cells to be used as input for the progress bar calculation

[basilbezirgan]

Thanks for video, but I think it's so fast when you describe the steps.

[princessmewtwo]

I don't think I can do this in my excel.