filmov
tv
How to Highlight Active Row #excel #exceltips #exceltricks #howto #spreadsheet #exceltutorial

Показать описание
VBA Code:
(Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub)
Conditional Formatting Formula:
Highlight Entire Row: =CELL("ROW")=ROW()
(Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub)
Conditional Formatting Formula:
Highlight Entire Row: =CELL("ROW")=ROW()