I want to add a column of cells together only if the particular cell is colored green. Can I do this using conditional formatting on a google spreadsheet?


2 Answers 2


No, Conditional formatting in Google Spreadsheets can only edit text and cell background color. You cannot use it to edit cell values. As Brian P pointed out you can use scripts to do it.


Yes, you can do this with a script (Extensions >> Apps Script) by using getBackground() in the Spreadsheet Service of Google Apps Script.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.