Want to click on 1 cell and have it hyperlinked to a highlighted c
 

I am currently working on a spreadsheet.... What I want to do sounds so
simple but is very difficult to figure out. I want to be able to click on A1
cell and have it hyperlinked to another cell B2, but at the same time have B2
highlighted.

Or I guess you can say is how can I click on A1 and have a section of this
highlighted yellow, once I click out of A1 the highligh dissapeares?

Any suggestions?

You would have to write a VBA macro, trapping the Selection_Change event to do
this.

On Sun, 30 Jan 2005 20:00:03 -0800, "GutterPunk"
wrote:

I am currently working on a spreadsheet.... What I want to do sounds so
simple but is very difficult to figure out. I want to be able to click on A1
cell and have it hyperlinked to another cell B2, but at the same time have B2
highlighted.

Or I guess you can say is how can I click on A1 and have a section of this
highlighted yellow, once I click out of A1 the highligh dissapeares?

Any suggestions?