Format cells if hovered over or selected

G

Guest

I want to be able to show visually which cells are linked to a cell when the
cell is either hovered over or selected. For example: If A1 is
selected/hovered over I want cells A5, B8, and B10 to highlight/change
colors. Does anyone know of a way to do this in VBA, I'm pretty sure it
can't be done using conditional formatting tool. Thanks.
-Adam
 
G

Guest

If you double click a cell containing a formula, the cells it refers to will
be bordered in different colours. Also, if you click in the formula bar, you
will get the same effect
 
G

Guest

Kassie said:
If you double click a cell containing a formula, the cells it refers to will
be bordered in different colours. Also, if you click in the formula bar, you
will get the same effect
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2
Highlight duplicate cells based on a selected cell 5
Advanced conditional formatting 3
How do I find data excluded from a list in excel? 2
Excel Conditional Formatting 1
Changing the default highllight for selected cells? 3
Combo Box 2
format cells range 9

Top