View Single Post
  #2   Report Post  
Héctor Miguel
 
Posts: n/a
Default

hi, Jose Juan !

When I am in one cell highlight another
... if my cursor is in A1... D1 highlighted or with another cursor on it.
... if I move to A2, D2 should be the one with another cursor or highlighted.


'put' a cursor on non-active-cell... [I don't think it's possible] :(
to highlight 'D' when activecell in 'A'...
- select 'D' [entire column]
- go to [menu] format / format conditions...
- formula: =and(cell("row")=row(),cell("column")=1)
- apply formats as needed [font, color, pattern...]
- right-click 'that' sheet-tab - view code...
- copy/paste the following lines...
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.ScreenUpdating = True
End Sub

hth,
hector.