Hello. This is my first time posting here on this forum. Nice to meet you all.

I am new to VBA in general and I'm not much of a tech savvy person but I am trying to learn VBA to make my tasks easier and efficient.

I am trying to make a Conditional Formatting on the three circles shown below on the picture. Basically what I'm trying to do is whenever I alter the percentages on cells L3, M3, and N3, the corresponding circle (A, B, and C) will change based on the colour (If Team A's score is 81%, it will turn orange, and vice versa).

sample1.PNG

I know that I can do the Conditional Formatting on one shape through VBA but is it possible to specify the shape to its assigned cell percentage? That's the part where I'm stuck at.

Any help would be very much appreciated.

Thank you.