format shapes depending on linked cells.

Hi,


I have 2 worksheets. In the Sheet 1, I have a data range A1:A100 with serial numbers in one of the column and on another Sheet 2, I have 100 shapes with their names from 1 to 100. I need to color individual shapes if the relevant cell is filled with a value on Sheet 1 . The purpose is to reflect the occupancy in sheet 2 through colored shapes (Visualisation).

Can someone help me a macro for it please?

Thanks in advance.

Aleena

Assuming you have Oval shapes (if not just modify the name preceding the number in the code), this event trap would be in the sheet 1 module:

Please Login or Register  to view this content.

Thanks for your reply.

I have tried it but it is not working. I have attached the workbook. Can you please check it and let me know what am I missing please?