Highlight active row/column in Excel

FastTrack-F1 

Another try...my link :))

Highlight active row and column without VBA

Actually, the VBA code should also work, but it has to be integrated into the workbook in advance from a subscription or desktop version, since you cannot create VBA code with online Excel.

However, you can open and edit the macro-enabled workbook in Excel for web.

Work with VBA macros in Excel for the web

Example VBA code input: Press ALT + F11 key combination to open VBA.

Then select ThisWorkbook in the left project explorer,

double click it to open the module,

and copy and paste the following VBA code into the blank module:

Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Excel.Range)

Static xLastRng As Range

On Error Resume Next

Target.Interior.ColorIndex = 6

xLastRng.Interior.ColorIndex = xlColorIndexNone

Set xLastRng = Target

End Sub

Add. Infos:

Show or hide gridlines on a worksheet