Excel macro to highlight related cells

sumit9909 - Jul 24, 2009 at 12:49 AM
 Trowa - Jul 28, 2009 at 07:40 AM

I have a worksheet for managing all documentation at our place.
I was trying to come up with a macro or a solution wherein I can group the related documents(in different cells, not necessarily contiguous). The idea is to have a feature wherein When I select any one of the related documents, all other documents(cells) in that group are highlighted.

I am using Excel 2003 with Vista.

Can anyone please help me with this?

Thanks in advance,

3 responses

Hello Sumit,

What is the connection between the group; what is the condition that makes certain documents a group?

Best regards,
Hi Trowa,

The connection is logical. These are documents for one process (templates, checklists, standards etc.)
Our intention was to be able to select one doc from the group and all other from the group are distinctively highlighted.

Hope it is clear.

Thanks and Regards,
Hi Sumit,

What you want to do sound to simple to create a macro for.

I would use the find function in excel: Ctrl + f.
Your groups are probaly in rows or columns, so click the top row or column to highlight the group.

Maybe someone else has a better solution for you.

Best of luck,