i want to perform format cells which contain characters "A" or "B" in google sheets
i have attempted "Text contains"
A,B
A|B
(A|B)
"A"|"B"
"A" or "B"
none of them work
or should i try "custom formula is"?
In the format rules choose 'custom formula' and then enter this formula
=regexmatch($B1;"A|B")
This should color the rows in the range B:C where the cells in column B contain A or B.
See if that works?