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

[vivpr]

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%