Data validation to show progress bars

Hi Daniel,

Thank you for the forum question.

You can create a progress bar based on selected percentage, but you cannot not have in one column.

I have created a worksheet I have attached, but without your if logic. I use 4 columns. First I added conditional formatting to the first column.

I used the formula =$a1=25% and I told Excel to highlight in light yellow. (conditional formatting -> New Rule -> Use a to determine which cells to format)

Then I selected the two first columns and used the formula =$a1=50% and I formatted with a darker yellow.

Then I selected the three first columns and used the formula =$a1=75% and I formatted with a light green.


Then I selected all 4 columns and used the formula =$a1=100% and I formatted with a darker green.

You will have to add your if logic to the formulas.

Be aware of the dollar signs in my formulas are very important to get it right.

I hope this can help you in the right direction.

Kind regards

Jens Bonde
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector