Google Sheets conditional formatting based on a series of values in a range

Viewed 257
1 Answers

Try

=not(iserror(MATCH(B4,$F$4:$F$7,0)))

Reference:

Related