This question already has an answer here:

I have Google Sheet 1 with a result in a cell that will turn green or red based on conditional statements that evaluate if the result is good or bad. On sheet 2 I would like to have post PASS or FAIL based on the color of the cell in sheet 1. Any help?


marked as duplicate by Rubén, serenesat, John C, Alex, jonsca Jun 4 at 18:19

This question has been asked before and already has an answer. If those answers do not fully address your question, please ask a new question.


not like you imagine but it can be done:

check this demo sheet: https://docs.google.com/spreadsheets/d/

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