...

View Full Version : Google docs formatting rows based on condition



StephenWeir
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.



EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum