Excel Conditional Formatting Escaping a Question Mark
- by kzh
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:
"?"
\?
'?'
??