How to highlight a row by looping column values via conditional formatting

Question

Trying to find a way to highlight a row based on a column value.

Tried out =countif(index($G$4:$G),A2)

But this only matches one cell and not the entire row. Have use =Search function but i was not able to loop the G column values only able to give static values.

Answer 1

You may try:

Apply to range: A4:E

Custom formula is:

=not(iserror(regexextract(join(" ",$A4:$E4),textjoin("|",1,$G$4:$G))))