Excel macro to highlight related cellsClosed

Question

Hello,

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,
Sumit

Trowa · Answer

Hello Sumit,

What is the connection between the group; what is the condition that makes certain documents a group?

Best regards,
Trowa

sumit9909 · Answer

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,
Sumit

Trowa · Answer

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,
Trowa

Excel macro to highlight related cells

3 responses

Similar discussions

Subscribe To Our Newsletter!