Mark,

I don't know what answers that you got previously, but have you tried a
simple UDF, like so

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function


and use that in the CF.

Or are you looking for just external reference formulae?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"markx" wrote in message
...
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