Hi,
Though this does not get you exactly what you want, you can conditionally
format all the formula based cells. Please follow the undermentioned
procedu
1. Go to Insert Name (name the formula as €ścellhasformula€ť) and in the
€śRefers to€ť box, type the following formula = get.cell(48,indirect(€śrc€ť,false));
2. Now in the conditional formatting dialog box, type cellhasformula and use
the desired formatting.
Hope this helps.
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Kathy Niebur" <Kathy
wrote in message
...
Is there a function in Excel or functions I could group together to
determine
if the contents of a given cell are a formula vs. a value ? For example,
I
would want to evaluate the contents of a cell displaying 3,450 to
determine
if that was a number typed into the cell (a numeric value) vs the result
of a
formula in the cell (=E5+E6) for example. I know how to manually display
the
formulas in a worksheet. I want to write a formula to CHECK for the
presence
or absence of a formula in a given cell. Being able to check for the
EXACT
formula would be even better. For example, =IF(B3<"=E5+E6","NOT
CORRECT',"CORRECT")
Any help?