| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| value of a cell / expression is a whole number | Excel Worksheet Functions | |||
| test expression for empty cell in =SUMIF() | Excel Worksheet Functions | |||
| test is text, not number.. | Excel Discussion (Misc queries) | |||
| "formula is too long" AND test for whether double-quotes are next-to text or number?? | Excel Discussion (Misc queries) | |||
| Formula that will test text conditions in a single cell | Excel Worksheet Functions | |||
Threaded Mode
