Hi guys
Im using a formula with conditional formatting and a change event code to highlight a selection of a row when a cell within that row is selected.
Everything works fine, however can I get this to only highlight the selection when the active cell is within a range.
The range I want is L10:P45, so if the active cell is within that range, the formating kicks in but if it isn't in that range then no formatting occurs.
Could I also have the formating to be applied if I only hover over a cell instead of clicking on the cell?
This is my formula for the conditional formatting:
=CELL("row")=ROW()
The event code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.ScreenUpdating = True
End Sub
Thanks
Im using a formula with conditional formatting and a change event code to highlight a selection of a row when a cell within that row is selected.
Everything works fine, however can I get this to only highlight the selection when the active cell is within a range.
The range I want is L10:P45, so if the active cell is within that range, the formating kicks in but if it isn't in that range then no formatting occurs.
Could I also have the formating to be applied if I only hover over a cell instead of clicking on the cell?
This is my formula for the conditional formatting:
=CELL("row")=ROW()
The event code:
Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Application.ScreenUpdating = True
End Sub
Thanks