View Full Version : Google docs formatting rows based on condition

06-28-2012, 04:00 PM
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.