| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Highlight the cells referenced in the active cell formula
I want to have the cells that are referenced in the active cells formula
highlight. For example if I have column A cell 1 with a formula of =sum(b2+c3+g6) I would like for the cells b2, c3, g6 to highlight yellow. The formula changes for each cell as do the referenced cells. Does anyone know if this is possible? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Row select mode to highlight active row of active cell | Excel Discussion (Misc queries) | |||
| Trying to highlight cells that have the same value as the active c | Excel Worksheet Functions | |||
| Highlight Cell Based Upon Referenced Cell Data | Excel Worksheet Functions | |||
| How to highlight cells referenced by other cells | Excel Worksheet Functions | |||
| Click in cell w/ formula and get colors in referenced cells | Excel Discussion (Misc queries) | |||
Threaded Mode
