Forum Discussion
Highlight active row/column in Excel
NikolinoDE Thanks for your proposals, but did you test them in Excel online? I cannot see a working solution!
https://support.microsoft.com/en-us/office/work-with-vba-macros-in-excel-for-the-web-98784ad0-898c-43aa-a1da-4f0fb5014343: "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...
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
- 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.