Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell or column highlights when other cell is selected
Hi,
I'm using Office 2003 and hoping for an answer. What I want to do is have either a cell or column highlight when another cell is chosen. For example when I select E4 then column J would highlight, or I select E4 and J4 would highlight. Are either of these possible? Tropicana |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell or column highlights when other cell is selected
You could do something like this. On sheet you want this to happen, right
click on sheet tab, view code, paste this in. This will highlight column J when E4 is selected. Private Sub Worksheet_SelectionChange(ByVal Target As Range) If Target.Address = "$E$4" Then Range("J:J").Interior.ColorIndex = 6 ' YELLOW Range("J:J").Interior.Pattern = xlSolid Else Range("J:J").Interior.ColorIndex = 0 End If End Sub -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Tropicana" wrote: Hi, I'm using Office 2003 and hoping for an answer. What I want to do is have either a cell or column highlight when another cell is chosen. For example when I select E4 then column J would highlight, or I select E4 and J4 would highlight. Are either of these possible? Tropicana |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
In VBA, How to Refer to Cell In Specific Column But Selected Rows? | Excel Discussion (Misc queries) | |||
one cell's value Highlights selected cells....how? | Excel Discussion (Misc queries) | |||
getting value 1 column to right of cell selected in pulldown | Excel Worksheet Functions | |||
can't highlight cell - highlights only cell's row and column | Excel Discussion (Misc queries) | |||
How to highlight row and column of the selected cell | Excel Discussion (Misc queries) |