Super User is a question and answer site for computer enthusiasts and power users. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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:

  • "?"
  • \?
  • '?'
  • ??
share|improve this question
up vote 39 down vote accepted

Prefix it with tilde

~?
share|improve this answer
    
Thanks for the quick answer. – kzh May 24 '10 at 21:20
3  
Thanks! This also works for Google sheets. – Vestride May 22 '15 at 23:58

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

share|improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .