Seeking Office Script Code to Highlight Active Row in Wide Excel Spreadsheet on SharePoint

Question

Hello everyone,

We're facing a challenge with a wide Excel spreadsheet housed on SharePoint that's utilized by multiple colleagues. Despite efforts to freeze certain columns and hide others, navigating through the extensive data remains cumbersome.

To enhance visibility and streamline our workflow, I'm looking for an Office script code solution that can dynamically highlight the active row. Whether it's the row containing the active cell or the row currently being worked on, the goal is to make it visually distinct from the rest of the data.

Having such a feature would greatly aid our team in quickly identifying and focusing on the relevant data during our collaborative efforts.

Any assistance or guidance on implementing such a script would be highly appreciated.

Thank you in advance for your help!