VBA to change multiple shapes color in Excel

[waseem11]

I'm beginner in Excel so i'm looking for a way by which if I type yes in a cell it should change color of multiple shapes with same color and if I type NO it should remove the color from those shapes and same goes for other zone entries as show below image.
Example: If i type On in G22&25 it should color 3 circles always with same color which is green in this case and if i type off it should remove the color from that circle.

 

[waseem11]

Here's the result. The first one only works for the first time and only do color of second circle from the right side.

Here's the sample file of it: DisplayBoardDynamicMapping - Copy.xlsx

 

[DanteAmor]

You have colors with conditional formatting.
You did not indicate that in your original petition.
You can change your colors from conditional formatting to standard colors and try again.

 

[waseem11]

oops!
Let me do and check that.

Thank you ^^

 

[waseem11]

it's working great. Thank you so much.
You rocked man!!!


Cheers

 

[DanteAmor]

I'm glad to help you. Thanks for the feedback.