Highlight ENTIRE Row and Column Automatically in Google Sheets!

Channel:

Office Expert

Subscribers:

49,700

Published on January 20, 2025 11:42:29 AM ● Video Link: https://www.youtube.com/watch?v=fuQTVATLeLQ

Duration: 0:00

450 views

23

Learn how to highlight entire rows and columns automatically in Google Sheets with this quick and easy tutorial! Whether you're working on a budget, tracking data, or creating a report, being able to quickly highlight entire rows and columns can save you time and increase your productivity. In this video, we'll show you a simple trick to achieve this in Google Sheets. From conditional formatting to clever formulas, we'll cover it all. So, if you're ready to take your Google Sheets skills to the next level, watch until the end and get ready to highlight like a pro!

code........................
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");
}
............................
--------------------------------------------------------------------------------------
We'd love to hear from you if you have any questions or collaboration proposals!
📧 Our Email: TechAiCenter1@gmail.com
♪ Tiktok: https://www.tiktok.com/@techai71