0

Google Sheets formula for outputting PASS or FAIL in one cell based on the color (green or red) of another cell?

  • I can't share the exact sheet as it has company information on it. So, what I am looking for is...I have a test result on a spreadsheet that the cell will turn green or red based on specification range it is compared to (have a conditional formula for that). Then I would like on another spreadsheet within the same file to post PASS if the other cell is green NCR if the other cell is red. Let me make up a dummy sheet if that helps – user190579 Jul 20 '18 at 12:03
  • do you know how to add a table in this application – user190579 Jul 20 '18 at 15:05
  • so let me summarize it... you have a cell that has conditional formatting set in a way that it will turn red or green and then you have another cell where you want to display pass or fail based on red/green cell... well, why not use that conditional formatting from a first cell directly as a criterion for your second cell in a way where you will use IF formula (like: =if( conditional formatting of cell A = green, display "pass", otherwise display "fail")) – MARK MY ANSWER Jul 20 '18 at 15:35
  • for further assistance, you will need to edit your question and add additional information: 1. conditional formatting formula/rule for green/red 2. which cell turns green/red 3. in which cell you need pass/fail to be displayed – MARK MY ANSWER Jul 20 '18 at 15:44
0

if you have a cell (A1) that has conditional formatting set in a way that it will turn red or green and then you have another cell (B1) where you want to display pass or fail based on red/green cell... use that conditional formatting from a first cell (A1) directly as a criterion for your second cell (B1) in a way where you will use IF formula like:

=if(conditional formatting of cell A1 = green, display "pass", otherwise display "fail")


  • Not sure if I am applying correctly but does not work. any thoughts – user190579 Jul 20 '18 at 17:41
  • @user190579 well this isn't an actual formula. its just analogy to help you to get there. you still didn't show whats your custom formula for conditional formatting. – MARK MY ANSWER Jul 20 '18 at 18:00
  • the custom formula is just linked to an index which helps decide the color of the cell. I just want to have on another spreadsheet either pass of fail based on the color. some initial searching says its not possible the way i am trying to do it. would need a script writer – user190579 Jul 20 '18 at 18:44
  • what do you think? – user190579 Jul 20 '18 at 18:45
  • @user190579 I think you should learn how to ask a question. to be able to help you I need to know enough about your problem so I would be able to craft some answer which will solve your problem. the main issue here is that you did not provide enough information ahead in advance so I need to pull it from you like hairs from a carpet until I get general idea whats the real issue - and this procedure is tiresome. you need to decide if you really want a help or not... – MARK MY ANSWER Jul 20 '18 at 19:26

Your Answer

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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