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.
|