Google Sheets conditional formatting if value in range

1
votes

I have a sheet that had a number of timeslots where people can put their names.

I have a list of names that I want to highlight if their name is not in the array of timeslots.

I can't seem to get this to work with conditional formatting.

This is what I've managed to do, I want to match the Names in the names column with any value in the array:

enter image description here

1
google-sheetsgoogle-sheets-formulags-conditional-formatting
row wise or whole wise? – player0
@player0 what is whole wise? – kishkin
@kishkin whole-wise like it will check names column no matter where those names in names column are located – player0
Like =(D1 <> "")*(IFERROR(MATCH(D1, B:B, 0), 0) = 0)*(IFERROR(MATCH(D1, C:C, 0), 0) = 0)? – kishkin
@kishkin more like: =REGEXMATCH(D2, TEXTJOIN("|", 1, B:B, C:C)) – player0

1 Answers

3
votes

highlight if their name is not in the array of timeslots

row-wise:

=(B2<>D2)*(C2<>D2)

0