I've tried "?" and '?'

The key to getting Excel to recognize ? as a character and not a wildcard is
by preceding it with the tilde character: ~?. The same is true with the *
wildcard vs the * character: ~*.

So, whatever you did in trying "?" and '?', try it like this ~?


--
Biff
Microsoft Excel MVP


wrote in message
...
Unfortunately it seems that any knowledge from versions previous to
2007 isn't applicable to the new Conditional Formatting paradigm in
2007. It's *entirely* different, using a rules-based system (similar
to Outlook Inbox rules wizards) and including a lot of new formatting
options that didn't even exist before.

While there are a lot more options to choose from, it seems to be very
prescriptive in the sense of not providing the ability to create free-
form formulas. There may be lots of options, but what you want had
better be within that predefined list. I'd be very happy if someone
proved me wrong on this and could tell me a way to accomplish what I
want.


Guy
----------------------------
User Experience Lead
San Francisco, CA