How to generate rectangle in excel 2007

[Chetan_raghu]

Hi All,

Excel 2007 When text is added in Col A,row 1-30 - a rectangle is generated - the text becomes the title of the rectangle - the rectangle's width + height are populated in col B+C If shape size is changed, the width + height is updated in the cell. Each shape has unique border color.

attachment_2ce0f3b358b78f26806b10b4cf6d1025.png

See file


Thanks,
Chetan

[Crooza]

Is this what you want

[Chetan_raghu]

Thank you very much Crooza!!!!