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

👍👍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...
Thank you! 👍👍
Download the featured file here: https://www.bluepecantraining.com/wp-...

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