How to highlight active cell row in google sheet?

Question

Google Apps Script

Work is being done in large tables and it is not convenient to substitute the ruler to the screen to see what the active cell belongs to. I tried using conditional formatting as it was done in EXCEL, but it does not work, the macro from EXCEL cannot be transferred either. I'm at a dead end!

Answer 1

You can try this function:
But it overwrites the background of the cells and does not work instantly.

function onSelectionChange ( e ) {
  let cache = CacheService.getDocumentCache();
  let range = e.range;
  
  let oldRow = cache.get("oldRow");
  if ( oldRow > 0 ) {
    e.source.getRange(oldRow+":"+oldRow).setBackground("#fff");
  }
  
  if ( range.getNumRows() === 1 ) {
    let row = range.getRow();
    
    e.source.getRange(row+":"+row).setBackground("#f3f3f3");
    
    cache.put("oldRow", row);
  }
}

Or like this:

function onSelectionChange ( e ) {
  let range = e.range;
  
  e.source.getRange("A:A").setValue("");
  
  if ( range.getNumRows() === 1 ) {
    let row = range.getRow();
    
    e.source.getRange("A"+row).setValue("SELECTED");
  }
}

I. set up conditional formatting: But the best option, in my opinion, is to write a script for your browser that would work on top of the page with the table. For example, through the tampermonkey extension . --- Maxim Stoyanov (stomaks), developer of Google Apps Script . g-apps-script.com stomaks.me
=IF($A1 = "SELECTED"; TRUE; FALSE)

Answer 2

If you use conditional formatting, it's easy. We set up for the first column so when we set 0 in the first column, the color of the line turns on, telling us about editing it. When we finish exercising with this line, we simply put one - the work is finished, and the line is marked with a different color. Even so))

Answer 3

I found how I wanted it to look. ( https://jsfiddle.net/x6c0bx4f/)
But does anyone know how to do the same in Google Sheets? (maybe a macro?)