Скачать или смотреть How to Highlight Active Cell Row in Microsoft Excel - AIO Tech Studio

Video#10 – A complete guide to How to Highlight Active Cell Row in Microsoft Excel.
#MicrosoftOffice #MSOffice #MSOffice #Excel #HighlightRow #ActiveCell


Chapters
00:00 Highlight Active Cell Row
00:31 Introduction
00:49 Setup
02:00 Example 1 - Data Set without Excel Table
07:11 Example 2 - Data Set with Excel Table

Note: Less Than and Greater Than sign not allowed in YouTube.
Example # 1 - Data Set without Excel Table
Conditional Formatting Formula - =AND(CELL("row")=ROW(),$B6*Less Than* & *Greater Than*"")
VBA Code -
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
Application.Calculate
End Sub


Example # 2 - Data Set with Excel Table
Conditional Formatting Formaula - =$B$1=ROW()
VBA Code -
Private Sub Worksheet_SelectionChange(ByVal Target As Range)

If Not Intersect(Target, Range("SalesData")) Is Nothing Then
Range("B1").Value = Target.Row
End If
Rows("1").Hidden = True

End Sub