1

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?

https://docs.google.com/spreadsheets/d/1WHEpsZrxRj0Z-xefTjkjnr7gH9AgAp8me1li3SXbB4Q/edit#gid=0

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.

0

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.