Search code examples
regexgoogle-sheetsconditional-statementsgoogle-sheets-formulaconditional-formatting

Google Sheets: Conditional Formatting Based On a Cell - If Contains String


In Google Sheets, is it possible to have conditional formatting on cell A1 that changes the colour if B1 contains the string "Hello World!", but not necessarily exactly the exact same?


Solution

  • try:

    =REGEXMATCH(LOWER(B1), "hello world")