I currently have a Google doc where I store a bunch of invoices and I want to be able to colour a whole row red if an invoice is overdue. I can do this for one cell but I can't work out how to build a script to colour a whole row.

I'd also like to be able to colour a row orange if it is due in the next 7 days and leave it green if it has been marked as paid.

There doesn't appear to be any solutions available to colour a whole row based on a condition.


Thanks in advance for any help you can provide.