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

[MeOfCourse]

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]

@MeOfCourse 

Please provide detailed information.

[#3]

@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.