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

F

Fred Holmes

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How can I test the text content of a cell 4
Conditional formula with text and number in cell 7
How do I evaluate whether a character is present in a cell? 4
Test for formula in cell 5
Logical value in time formula? 4
IF OR AND in same conditional formula 2
Format cells and font by content/whether formula present 2
how can i test whether cell contains keyed constant or a formulae 6

Top