Search code examples
google-sheetsconditional-formatting

Apply conditional formatting to any cell in Col A that matches the value of any cell in the range B3:B11

In google sheets, I would like to apply conditional formatting to any cell in Col A that matches the value of any cell in the range B3:B11 See sample image.

sample conditional formatting I'm trying to achieve

I tried "custom formula is": =A3=B3:B11 over the range A3:A11, but that created unexpected results

Solution

  • If you have both text or numbers you can use this:

    =SUM(--ARRAYFORMULA(OR(A1=$B$3:$B$11)*(A1<>"")))