Highlight Row & Column in Selected Cell in Excel
To highlight rows and columns when selecting a cell, you must follow the steps taught in the video.
0:00 Introduction
0:10 Define new Rule from conditional formatting
0:18 Set Row formula ROW()=CELL("row")
0:52 Set VBA Formula (Application.Calculate) in worksheet
1:26 Set Column formula COLUMN()=CELL("col")
2:00 Mange Rules to Change Color
2:22 Remove Header from Rules
#Highlight
#Excel_Tutorial
#Highlight_Row
#Highlight_Column
#Conditional_Formatting
#ROW()
#Application.Calculate
#COLUMN()
#Mange_Rules
#Worksheet
1 июл 2024