Cell data changes its Specified fill shape color

Hello, I just joined this sight and am very new to VBA. I am currently in the process of trying to understand the function. I am in request of a code that would change the Shape Fill color based on cells drop down menu value, the values are 4mm, 6mm, 8mm, and stop". The code I am looking for function would take the value from the cells in the "Z" column and turn the specific oval either blue, red, yellow, or green. I tried to use a code similar to what i was looking for but I had no luck when putting in my data.

any help or a point in the correct direction would be greatly appreciated


I have attached a sample file to this thread.

Okay, I renamed as you said. Is there anything I could study to understand how this actually works? I would really like to understand the whys and why nots.

Awesome, this is exactly what I was looking for. thank you