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?
Yes, you can do this with a script (Tools >> Script editor) by using getBackgroundColor() in the Spreadsheet API.
Sign up using Google
Sign up using Facebook
Sign up using Stack Exchange
By posting your answer, you agree to the
terms of service.
7 months ago
4 months ago