How to highlight the currently hovered row in excel?

Question

excel

______________________________________________excel 2016

Answer 1

You need to write a macro, or install a ready-made addon.
If by yourself, then you can do this:
https://trumpexcel.com/highlight-active-row-column...
Briefly - conditional formatting, select the range in which you need highlighting, create a new conditional formatting rule:
=OR(CELL("COL")=COLUMN(),CELL("ROW")=ROW())
Adjust the selection color there.
Then you create a handler

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Application.CutCopyMode = False Then
Application.Calculate
End If
End Sub

In vba file module. The table will have to be saved as xlsm. On large tables it will slow down.
Here are two similar (according to the mechanism of operation), but slightly different options.
https://lifehacks365.com/2019/10/11/automatically-...
https://stackoverflow.com/questions/22349424/highl...
If Excel is Russian for some reason, the formulas and separators will be Russian, respectively.
PS
This method, by the way, does not reset the undo stack, unlike some alternative ones.