Highlight formulas

P

Philip Reece-Heal

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
 
F

Frank Kabel

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
 
Top