Test whether formula in cell is an expression or a number/text
 

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

Test whether formula in cell is an expression or a number/text
 

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

Test whether formula in cell is an expression or a number/text
 

Looks good.
Thanks,
Fred Holmes

On Tue, 9 Jun 2009 12:01:04 -0400, "T. Valko"
wrote:

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

Test whether formula in cell is an expression or a number/text
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Fred Holmes" wrote in message
...
Looks good.
Thanks,
Fred Holmes

On Tue, 9 Jun 2009 12:01:04 -0400, "T. Valko"
wrote:

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