How to highlight Selected Row and Column (With & Without using VBA)
Hello everyone, In this video, I have discussed, how to highlight the row and column of a selected cell.
By applying the Excel conditional formatting function and 4 simple functions, you can easily highlight the row and column of the currently selected cell.
🔸 Conditional Formula used in this tutorial:
=OR(CELL("ROW")=ROW(),CELL("COL")=COLUMN())
🔸 Macro Code used:
-----------------------------------------------------------------------------------------------------------
Private Sub Worksheet_SelectionChange ( ByVal Target As Range )
If Target . FormatConditions . Count 0 Then Me . Calculate
End Sub
-----------------------------------------------------------------------------------------------------------
🔽 Download the working file: shorturl.at/swBGY
#Excel #HighlightCells #ConditionalFormatting
Watch video How to highlight Selected Row and Column (With & Without using VBA) online without registration, duration hours minute second in high quality. This video was added by user SD Motion 08 December 2021, don't forget to share it with your friends and acquaintances, it has been viewed on our site 6,268 once and liked it 48 people.