Have Other Cells Highlight When One Cell Is Highlighted

[mgarcia]

Hello,

I'm not sure if this could easily be done or is possible, but hoping someone can help me out. I do a lot of shipping and have use for calendars in Excel for marking dates something is ordered, date it needs to ship and date it will deliver. This can vary by item and my calendar can get cluttered with multiple information. I was wondering if it would be possible to link cells together so that when I click on a cell in my calendar, other cells that contain information pertaining to that cell are also highlighted/stand out.

Similar to when you are editing a formula in Excel and it shows all the cells that relate to the formula in different colors. Would this be possible?

Thanks in advance for any help!

[Jdevil]

You can do this with VBA. If you want the code, you will need to give more information though (or send a file without confidential information)

Please Login or Register  to view this content.

In there you could first, look at the selection value
Then you loop in other cells and look which ones are corresponding
Then you change the colors accordingly

Other than that, I don't know, good luck