I could use some help with conditional formatting.
I would like to format the first 6 cells in a row in a Google Docs file based on the following condition: If column A is not empty and column C is, change the background of the cells in A-F to red.
How can I do this?
Best Answer
In your spreadsheet, go to tools, click script editor, and create a blank script. Replace any text inside the script with this function.
You will need to change Sheet1 to whatever the name of your sheet is. Then, while still in the script editor, click resources, 'current project triggers.'
Add a new trigger with 'Run' set to paintRed and Events set to 'From spreadsheet' 'On edit.'
You should be good to go.
Link to spreadsheet you can copy to your drive, then play with - https://docs.google.com/spreadsheet/ccc?key=0Ar6b2EOADTG7dGJOM0lEalhjd3pNOHNRNnBDOV8xRnc&usp=sharing