1

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

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.