CODEWITHSUNDEEP
regexgoogle-sheetsgoogle-sheets-formulagoogle-sheets-querygs-conditional-formatting
Leitutolu Rasmussen
Leitutolu Rasmussen

Reputation: 9

How do you highlight a row if criteria has been met?

Im using Google Sheets and I am trying to highlight a row Green if the numbers 1,2,3 and 4 are found within the outcome row. The whole row would be highlighted indicating whether or not it was successful.

You can view my work here https://docs.google.com/spreadsheets/d/12kOGdkq9P78gCojHJGW0xPVNXaTFAbFDZ4JLEX09H0U/edit?usp=sharing

I have tried conditional formatting but I cant seem to get it to work.

Upvotes: 0

Views: 84

Answers (3)

Tom Sharpe
Tom Sharpe

Reputation: 34265

Also just for fun

=arrayformula(($B1="Outcome")*product(countif($C1:$L1,{1,2,3,4})))

Upvotes: 2

Erik Tyler
Erik Tyler

Reputation: 9355

I've added another sheet to your spreadsheet (called "Erik Help"), which offers another alternative (which I've applied to B1:L60):

=ArrayFormula(($B1="Outcome")*(RIGHT(JOIN("",SORT(UNIQUE(TRANSPOSE($C1:$L1)),1,1)),4)="1234"))

Upvotes: 1

player0
player0

Reputation: 1

try:

=($B1=$B$2)*
 (REGEXMATCH(TRANSPOSE(QUERY(TRANSPOSE($C1:$L),,9^9)), " 1 |1 | 1"))* 
 (REGEXMATCH(TRANSPOSE(QUERY(TRANSPOSE($C1:$L),,9^9)), " 2 |2 | 2"))* 
 (REGEXMATCH(TRANSPOSE(QUERY(TRANSPOSE($C1:$L),,9^9)), " 3 |3 | 3"))* 
 (REGEXMATCH(TRANSPOSE(QUERY(TRANSPOSE($C1:$L),,9^9)), " 4 |4 | 4"))

0

Upvotes: 0

Related Questions