If you have found this content useful and want to show your appreciation, please use this link to buy me a beer .
https://www.paypal.com/donate/?hosted_button_id=CGKRY2BAYEQBQ
Thank you!
Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/03/Progress-Bar.xlsx

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
————————

Please take the opportunity to connect and share this video with your friends and family if you find it useful.