If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|