| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
"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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| format cells dialog box does not come up | Excel Discussion (Misc queries) | |||
| Select format cells Custom but Saves As Specil Why. | Excel Worksheet Functions | |||
| How do I get brackets in format cells accounting? | Excel Discussion (Misc queries) | |||
| My sheet is unprotected, but I can't format cells. | Excel Discussion (Misc queries) | |||
| Find cells without multiple spacebars and format... | Excel Discussion (Misc queries) | |||
Linear Mode
