• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Select and highlight shape when Cell changes

saamrat

Member
Dear Friends,

Please help to find a solution. Excel sheet attached.

When B1 changes, corresponding shape to be selected and highlighted as shown in the sheet.
I have drawn shape over the image and kept the fill none. when B1 Changes, shape to be selected and fill accordingly.
Is this possible ?

Please help
 

Attachments

  • Selection_shape.xlsx
    242.9 KB · Views: 1
Hi p45cal,

That was brilliant !!!.
I need a small change in the layout. If marked as "SOLD", a text box to be placed against the respective plot.
Kindly help. File attached.
 

Attachments

  • Chandoo45280Selection_shape.xlsm
    253 KB · Views: 5
Back
Top