Excel Progress Bar chart with Conditional Formatting that Changes Color Based on Value

vivpr

New Member
Joined
Sep 17, 2017
Messages
2
I would like create a bar chart in Excel to show the progression that will change color based on the % completed towards goal.



I want the progress bar to follow the below color scheme format:

<80% = Red Bar
>=80% = Green Bar




I want this to be one single bar that changes color based on the % values in another cell

The bar itself would chart progress from 0% to a maximum of 100%
 

Some videos you may like

Excel Facts

Copy formula down without changing references
If you have =SUM(F2:F49) in F50; type Alt+' in F51 to copy =SUM(F2:F49) to F51, leaving the formula in edit mode. Change SUM to COUNT.

Watch MrExcel Video

Forum statistics

Threads
1,100,191
Messages
5,473,041
Members
406,843
Latest member
David_Welland

This Week's Hot Topics

Top