Highlighting Row and Column of Selected Cell using Google Apps Script

submit.md

Highlighting Row and Column of Selected Cell using Google Apps Script

This is a sample script for highlighting the row and column of the selected cell using Google Apps Script. For this, the OnSelectionChange event trigger is used.

Demo

Sample script

Please copy and paste the following script to the script editor of Spreadsheet. And, please select a cell. By this, the script is run by the OnSelectionChange event trigger.

function onSelectionChange(e) {
  const range = e.range;
  const sheet = range.getSheet();
  const maxRows = sheet.getMaxRows();
  const maxColumns = sheet.getMaxColumns();
  sheet.getRange(1, 1, maxRows, maxColumns).setBackground(null);
  sheet.getRange(1, range.getColumn(), maxRows, 1).setBackground("yellow");
  sheet.getRange(range.getRow(), 1, 1, maxColumns).setBackground("yellow");
}

References

• Simple Triggers
• onSelectionChange(e)

Help, I copied and pasted the code, and set triggers but code doesn't work.

@kenomd Thank you for your comment. I have to apologize for my poor English skill. Unfortunately, from Help, I copied and pasted the code, and set triggers but code doesn't work., I cannot understand your current situation. Because when I tested my sample script, unfortunately, I can confirm that the script works fine. This is due to my poor skill. I deeply apologize for this. In order to correctly understand your issue, can you provide the detailed flow for correctly replicating your issue? By this, I would like to confirm it. If you can cooperate to resolve your issue, I'm glad. Can you cooperate to do it? By the way, also I cannot understand set triggers in your comment.

Kanshi - your code is working now. Don't know what I changed to make it work but it's working fine now -- just a little bit slow but I suppose that's to be expected running an on-line app. Maybe just closing and re-opening the file several times did the trick. Do you know what google means by 'refresh' in this description of the onChange trigger? The onSelectionChange(e) trigger runs automatically when a user changes the selection in a spreadsheet. To activate this trigger, you must *refresh *the spreadsheet once the trigger is added and every time the spreadsheet is opened. The set triggers is this feature, part of the scripts editor package -- I don't know exactly what it does but it didn't seem to effect your code. [image: Screenshot (1).png] Thanks for the code, it's working great!

…

On Mon, Jan 3, 2022 at 2:42 AM Kanshi TANAIKE ***@***.***> wrote: ***@***.**** commented on this gist. ------------------------------ @kenomd <https://github.com/kenomd> Thank you for your comment. I have to apologize for my poor English skill. Unfortunately, from Help, I copied and pasted the code, and set triggers but code doesn't work., I cannot understand your current situation. Because when I tested my sample script, unfortunately, I can confirm that the script works fine. This is due to my poor skill. I deeply apologize for this. In order to correctly understand your issue, can you provide the detailed flow for correctly replicating your issue? By this, I would like to confirm it. If you can cooperate to resolve your issue, I'm glad. Can you cooperate to do it? By the way, also I cannot understand set triggers in your comment. — Reply to this email directly, view it on GitHub <https://gist.github.com/3e6b6bbc13cd9814aa918c9933fb862f#gistcomment-4014664>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/AXEBWKZMROBD43SHAVNN5E3UUFHNLANCNFSM5LEDKYAQ> . Triage notifications on the go with GitHub Mobile for iOS <https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675> or Android <https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign%3Dnotification-email%26utm_medium%3Demail%26utm_source%3Dgithub>. You are receiving this because you were mentioned.Message ID: ***@***.***>

-- Ken Lee */***Every election is a sort of advance auction sale of stolen goods. Henry Louis Mencken **/

Thank you for replying. I'm glad your issue was resolved.