57
8
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:
kzh
Posted 2010-05-24T21:04:28.853
Reputation: 3 213
82
Prefix it with tilde
~?
Sharjeel Aziz
Posted 2010-05-24T21:04:28.853
Reputation: 2 643
3
Change the rule to "cells ending with" "?". This will color all cells with a question mark assuming it is the last character.
kzh
Posted 2010-05-24T21:04:28.853
Reputation: 3 213
2
Also you can use Specific Text > Contains > ~? This tells excel to ignore symbol command and treats the cell as text.
user667254
Posted 2010-05-24T21:04:28.853
Reputation: 21
21Prefix with a
~? Seriously ? What the rofl... Does anyone have an idea why ? Anyway, huge thanks. I'd never have figured out such a syntax alone. – Balmipour – 2017-06-27T15:43:18.497