Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
click on one cell to find and highlight a related cell?
is there a way to have i.e. a list of people's names in one column, and a
list of company regions in another column, so that whenever you click on a person's name in the first column, Excel highlights that person's region in the second column? (so the user can find out any person's Region, by clicking on their name.) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
click on one cell to find and highlight a related cell?
Place the following macro in the worksheet code area:
Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Intersect(Target, Range("A:A")) Is Nothing Then Exit Sub Application.EnableEvents = False Range("B:B").ClearFormats Target.Offset(0, 1).Interior.ColorIndex = 6 Application.EnableEvents = True End Sub If you select a cell in column B, then the equivalent cell in column B will be hi-lighted. -- Gary''s Student - gsnu200742 "JustSomeGuy" wrote: is there a way to have i.e. a list of people's names in one column, and a list of company regions in another column, so that whenever you click on a person's name in the first column, Excel highlights that person's region in the second column? (so the user can find out any person's Region, by clicking on their name.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to click on a cell and have the content of the cell display in a different cell | Excel Worksheet Functions | |||
How do I double click a cell and jump to cell's referenced cell | Excel Discussion (Misc queries) | |||
Click on graph bar to execute a double-click in a pivot table cell | Charts and Charting in Excel | |||
Highlight cells with ctrl-click but only un-highlight one cell | Excel Discussion (Misc queries) | |||
Click on cell-calendar drops down-click on date-date fills cell. . | Setting up and Configuration of Excel |