Highlight formulas

[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

 

[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