Take the 2-minute tour ×

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
add comment

2 Answers

up vote 13 down vote accepted

Prefix it with tilde

share|improve this answer
Thanks for the quick answer. –  kzh May 24 '10 at 21:20
add comment

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
add comment

Your Answer


