Hi guys,

Some time ago, I posted the question below, but didn't receive any 100%
satisfactory answer. Could you take a look at this? Thanks!

-------------
What is the best way to highlight (or even color) all the cells in a
worksheet (or even in a workbook) containing a specific character? For
exemple, I would like to make visually distinctive all the cells containing
somewhere a "?" character (or "mmm" string, or "!" mark, or "=" sign).

Are you aware of any special easy macro doing (and also undoing) this kind
of stuff?
Or do you have idea how to write a special formula to put in "conditionnal
formatting" part?
-------------
(To be more precise, I would like to find not only the cells where the
reqested sign is the only one (f. ex. "?" in cell A1="?"), but also the
cells where this sign is one parmi others (like f. ex. finding "?" in cell
A2="mxz?wptex").

* * *
One of my goals is to find (through this method) all the formulas (as they
contain "=" sign), references to other sheets (looking for the "!" sign) and
worksheets ("[", "]" and ".xls" signs). Please let me know if there is any
other (simplier and more reliable) way to do this...

Once again, many thanks folks!
Mark