Google Sheets formula for outputting PASS
or FAIL
in one cell based on the color (green or red) of another cell?
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. – user0 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
-
-
@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... – user0 Jul 20 '18 at 19:26
IF
formula (like:=if( conditional formatting of cell A = green, display "pass", otherwise display "fail")
) – user0 Jul 20 '18 at 15:35