Learn auto highlighting selected cell's row and column in google sheets. This we do by using app script feature of Google Sheets.
Copy the code from below.
function onSelectionChange()
{
var range = SpreadsheetApp.getActiveRange();
var sheet = range.getSheet();
var rows = sheet.getMaxRows();
var columns = sheet.getMaxColumns();
sheet.getRange(1,1,rows,columns).setBackground(null);
sheet.getRange(1,range.getColumn(),rows,range.getNumColumns()).setBackground("yellow");
sheet.getRange(range.getRow(),1,range.getNumRows(),columns).setBackground("yellow");
}
Негізгі бет How to Auto Highlight Active Cell Row and Column in Google Sheets
Пікірлер: 24