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