Excel Conditional Formatting Escaping a Question Mark

Question

I would like to use a conditional formatting rule in an excel file that would color any box with a question mark in it red. It seems that Excel is using a question mark as a wild card and will turn all cells with at least one character in them red. How can i escape the question mark?

These don't seem to work:

• "?"
• \?
• '?'
• ??

Answer 1

Prefix it with tilde

~?

Answer 2

Change the rule to "cells ending with" "?". This will color all cells with a question mark assuming it is the last character.