its a nice question..but i cant directly give you a formula since i dont have
my xlsoffice in this comp...
I guess others may reply you with some *if*+*find*+*char* blend of functions
for your conditional formulation that may highlight most of your *Question*
concerns in the matrix.

--
regards,
driller

" wrote:

I'm setting up a mostly text matrix (used for tracking tasks and
priorities in a larger project). What I'd like to do is set up
Conditional Formatting to highlight any cell which contains a question
mark, so that it will be blatantly obvious any time anyone on the team
enters a question anywhere in the matrix (whether as "notes" or in a
specific field to show that they don't know what to put there).

The problem is that in Excel 2007's implementation of Conditional
Formatting, the question mark appears to *only* be usable as a
wildcard which represents any character, and I cannot find any way to
tell Excel that I want to test cell contents for the actual question
mark character. I've tried "?" and '?' which only results in matching
for the quotation mark(s) with any character between them.

Does anyone know how to accomplish this? Is it even possible in Excel
2007?

Thanks!