See this:

http://groups.google.com/group/micro...cf859ecd?tvc=2

--
Biff
Microsoft Excel MVP


"Fred Holmes" wrote in message
...
Excel 2000

Is there a test criterion for use in conditional formatting of a cell
that tests simply whether the formula in the cell in question is 1) a
number or text (i.e., is "hard coded"), or 2) is an expression (which
evaluates data and produces a result?

TIA

Fred Holmes