Highlight formulas
 

Does anyone know of a function that can identify if a cell has a formula in
it, as opposed to a number or text.

Any help appreciated

Philip

Hi
not without using VBA. You may use a UDF such as
public function is_formula(rng as range) as boolean
is_formula=rng.hasformula
end function

--
Regards
Frank Kabel
Frankfurt, Germany

"Philip Reece-Heal" schrieb im
Newsbeitrag . ..
Does anyone know of a function that can identify if a cell has a
formula in
it, as opposed to a number or text.

Any help appreciated

Philip