Search code examples
google-sheetsconditional-formatting

OR in custom conditional formatting formula


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?


Solution

  • 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.