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?

CodePudding user response：

try:

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