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?



1 Answer 1


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.