I am trying to create a conditional format which will highlight the specific
cell red when it brings up an error.

If column O is filled in without column M having the text "offer" in it, I
want it to turn red. I want this if an option has been chosen in column O,
not if column O is blank.

Any ideas?