Format cells if hovered over or selected
 

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

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

"Adam R" wrote:

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

"Kassie" wrote:

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

"Adam R" wrote:

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