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?
Google-sheets – Google Spreadsheets Conditional Formatting with color
conditional formattinggoogle sheets
Related Topic
- Google-sheets – Conditional formatting of an entire row based on multiple cells
- Google-sheets – Apply conditional formatting based on the formula that a cell contains
- Google-sheets – Conditional Formatting, Negative Numbers
- Applying Conditional Formatting Color Scale to Non-Numerical Cells in Google Sheets
- Google-sheets – Copying Cell Color from Conditional Formatting in Google Sheets
- Google-sheets – Google Sheets Conditional Formatting Isn’t Working
- Google Sheets – Conditional Formatting Based on Data in Two Columns
Best Answer
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.