Search : in
By :

Excel macro to highlight related cells

Last answer on Jul 28, 2009 12:40:35 pm BST sumit9909, on Jul 24, 2009 5:49:26 am BST 
 Report this message to moderators

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

Configuration: Windows Vista Internet Explorer 7.0

Best answers for « Excel macro to highlight related cells » in :
Excel Macro for deleting rows IF cells not... Show
Excel – Macro to detect and hide blank rows Show Excel – Macro to detect and hide blank rows Issue Solution Note Issue I want a macro to unhide about 20 blank rows copy values into the top row then hide the remaining rows (some cells have fill though) then the next time it will...
Excel Macro Help Please (Solved) Show
Basic Excel Formulas ShowBasic Excel Formulas Below are some basic formulas for Microsoft excel: Basic formula : ADDITION cell A1 to A10 = sum (A1: A10) AVERAGE cell A1 to A10 = average (A1: A10) MAXIMUM cell A1 to A10 = max (A1: A10) MINIMUM...
Excel - Send value of cell to target ShowExcel - Send value of cell to target Issue Solution Note Issue Is it possible to send the value of a cell (copy and paste special) to another cell where the value would not be disturbed when the source value changes to '0'? My...
Excel – Macro for copy & paste selected range ShowExcel – Macro for copy & paste selected range Issue Solution Note Issue I have a summary of data by month in one sheet and the raw data in another sheet. Instead of creating multiple worksheets for my raw data for each month, I want...
Worksheet - Cells ShowThe Concept of a Cell A "cell" is the intersection between a line (horizontal) and a column (vertical) on a worksheet. Thus, the name of the line combined with the name of the column gives the cell's coordinates (the term address is sometimes also...
Ask your question Reply

1

Trowa, on Jul 24, 2009 11:58:34 am BST

Hello Sumit,

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

Best regards,
Trowa

   
Reply to Trowa

2

sumit9909, on Jul 24, 2009 3:14:20 pm BST

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

   
Reply to sumit9909

3

 Trowa, on Jul 28, 2009 12:40:35 pm BST

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

   
Reply to Trowa
Ask your question Reply
They need your help