Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
06-28-2012, 04:00 PM #1
- Join Date
- Jun 2012
- Thanked 0 Times in 0 Posts
Google docs formatting rows based on condition
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.