Highlight active row/column in Excel

[FastTrack-F1]

Hello,

for the Excel desktop app there are different ways to highlight an active row/column.

In Excel Online I sometimes really struggle to see the active cell, especially in meetings when presented by projector.

Is there any way to get these settings changed in Excel Online?

Thanks 

[#2]

@FastTrack-F1 

Highlight active cell

Here is a link that might help you :).

NikolinoDE

[#3]

@NikolinoDE Thanks, but the solutions do not apply to Excel Online...

[#4]

@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

[#5]

@NikolinoDE Thanks for your proposals, but did you test them in Excel online? I cannot see a working solution!

Work with VBA macros in Excel for the web: "Although you can't create, run, or edit VBA (Visual Basic for Applications) macros in Excel for the web,..."

Conditional formatting also does not work, as it needs manual recalculation...

[#6]

@FastTrack-F1 

There is no built-in way to do what you want in Excel Online

Perhaps Office Scripts can do it.

[#7]

@FastTrack-F1 

Unfortunately I didn't try it in Online Excel.

Sry it can't work in excel online.

As Mr. Vogelaar mentioned, it is not possible to highlight an active cell except with Office Script. Recommend a subscription version or a desktop version of Excel to be able to use all functions or as mentioned, Office script.

Thank you for your understanding and patience

[#8]

Thank you both, unfortunately it has to be Excel online and not desktop app.
Office script could be a workable solution I have to look into.