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.
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"))