| 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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| 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 | |||
Hybrid Mode
