In Google Sheets I have a table like this:
+-------+-------+------+------+-------+
| A | B | C | D | B |
+-------+-------+------+------+-------+
| color | color | none | none | color |
+-------+-------+------+------+-------+
and I would like to color the background of cells that contain A
or B
.
Is there any custom formula that could help with this?
Assuming the relevant row is the first, please select it and try Format - Conditional formatting..., Custom formula is and:
=or(A1="A",A1="B")
Choose your Formatting style and Done.