Excel macro to highlight related cells [Closed]

Question

Excel macro to highlight related cells [Closed]

Report

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

Excel macro to highlight related cells
Excel - Macro to highlight Rows with Duplicate values in a cell ✓ - Forum - Excel
Excel Macro - using integers as cell referenc ✓ - Forum - Excel
Excel macro highlight cell based on value ✓ - Forum - Programming
Compare two excel sheets and highlight differences macro ✓ - Forum - Excel
Excel macro insert picture based on cell value - Forum - Excel

3 replies

Ask a question

Trowa · Answer 1 · 2009-07-24T06:58:34-0400

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

sumit9909 · Answer 2 · 2009-07-24T10:14:20-0400

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 3 · 2009-07-28T07:40:35-0400

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 [Closed]

3 replies

Your reply

Subscribe To Our Newsletter!