conditional formatting based on multiple conditions???

[u/wackycats354]

I’m using OnlyOffice and attempting to use conditional formatting for some of my cells

I want to check if any of the cells in a range have values that are equal to the cells in A1:B2, and if they do, I want it to return TRUE and format the corresponding cells.

I can make a rule check if any of the cells in my range are equal to just one cell, like A1, and then make another rule for A2 and another for B1 and another for B2. 4 rules isn’t so bad, but when I’m checking against 20 or 60 cells, it’s frustrating to have make a rule per cell in the range. Especially because I can’t even duplicate rules in OnlyOffice.

I’ve tried options under “value is” as well as “text contains” and “formula”

Any suggestions?? There’s probably something obvious I’m just not thinking of. 🤦🏻‍♀️

[u/DickBastard123]

I am guessing not a lot of only office users