Bar graph color changing w/values

[pglibra]

Greetings,
My question is regarding the changing the colors of a bar graph based on value.
For example, if the value in the cell is 550, I want the color to stay green up to 500 and then change to red for anything over 500 up to the 550.

Thank you for your assistance.

Paul

 

[pgc01]

Hi Paul

Jon Peltier explains here how:

Conditional Formatting of Excel Charts - Peltier Tech Blog