How to setup a single cell that when clicked will highlight data in other cells

%3CLINGO-SUB%20id%3D%22lingo-sub-2736899%22%20slang%3D%22en-US%22%3EHow%20to%20setup%20a%20single%20cell%20that%20when%20clicked%20will%20highlight%20data%20in%20other%20cells%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2736899%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there%2C%3C%2FP%3E%3CP%3EI'm%20running%20windows%208.%3C%2FP%3E%3CP%3EDoes%20anyone%20know%20how%20I%20can%20click%20a%20single%20cell%2C%20which%20then%20will%20highlight%20data%20in%20other%20selected%20cells%3F%3C%2FP%3E%3CP%3EI%20can't%20seem%20to%20figure%20it%20out.%3C%2FP%3E%3CP%3EThanks%2C%20in%20advance%2C%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2736899%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hi there,

I'm running windows 8.

Does anyone know how I can click a single cell, which then will highlight data in other selected cells?

I can't seem to figure it out.

Thanks, in advance,

2 Replies

@MeOfCourse 

Please provide detailed information.

@Hans Vogelaar 

Hi there, Thanks for the response back.

However, I was able to figure out my question.

I figured out how to accomplish this with the use of Macros and it seems to be working great.

Thanks again.