Previous Topic Next Topic

Excel macro to highlight related cells

Closed
sumit9909 - Jul 24, 2009 at 12:49 AM
 Trowa - Jul 28, 2009 at 07:40 AM
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

3 replies

Answer 1 / 3
Trowa
Jul 24, 2009 at 06:58 AM
Hello Sumit,

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

Best regards,
Trowa
0
Answer 2 / 3
sumit9909
Jul 24, 2009 at 10:14 AM
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
0
Answer 3 / 3
Trowa
Jul 28, 2009 at 07:40 AM
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
0