Percentage Progress Bar in Excel With Conditional Formatting | Change Colour Based on Value in Cell

In this Microsoft Excel video tutorial I demonstrate two ways of creating a percentage progress bar. The first method uses conditional formatting data bars: this is the easiest method.

The second method uses conditional formatting in conjunction with the REPT function. The REPT function repeats a character or characters the number of times you specify. In this scenario we want to repeat the pipe character (|). By repeating the pipe character we can create what looks like a solid bar. We can also apply conditional formatting to the pipe character to change its colour based on other values.

Table of Contents:

00:00 - Introduction
00:29 - Method 1: Conditional formatting using Data Bars
01:55 - Method 2: Using the REPT function and conditional formatting
------------------------

[hdcreAtions]

THANK YOU
THIS VIDEO HELPED ME A LOT!!

[silviopoggi]

Thank you so much for your continued efforts and time. I always enjoy your presentations!

[IvanCortinas_ES]

As always a splendid video. A very professional presentation of graphics. Thank you very much Chester!!!

[simplirv]

Thank you!!! Fantastic video. Perfect method and instruction. Your video helped me immensely. 😊 July 17, 2024

[carmenvega]

excellent and simple thanks so much will be viewing your other videos. Want to create multiple color bars

[a]

Very informative! I'll begin changing the color of the progress bars with the smaller values.

[markcollins]

Great video and presentation of instructions.

[tyroneashby]

Chester brilliant as ever thank you so much.

[zahoorsarbandi]

Very nice. thanks for sharing your knowledge. I am regularly watching your videos.. each of the tutorial is having some new techniques of doing things differently.

[robkmills]

Hi great information. I have tried your video showing having different coloured progress bars to show different percentage but cannot get the colour change been through several times without any luck. Any idea?

[maythamalmouthen]

Thank you, after i complete the first method and end with one color bars (blue), can i use conditional formatting formula only without formula “REPT” and change font, to have bars with different colors?