Slowly trying to pull myself away from Excel and onto Google Sheets, but hit a sticking point.
Per the below screenshot, column L is formatted to colour code based on folio allocation percentage.
Is there a function in sheets that will format the rest of the table’s row to match that of column L automatically? I know you could do something along these lines in Excel but I’ve forgotten how and I think it highlighted the entire row, not just to the borders of the table.
Any experts that can advise would be most appreciated.