How can I find out if a cell in Excel contains a number/text or a formula?

Question

What I like to do is conditionally format cells depending on whether the cell contains a formula (something starting with "=") or not.

Is this feasible in Excel 2007?

Answer 1

You can use:

If (cell.HasFormula) then ..

To look for formulas.

(This will avoid the problem of literal string field starting with an "=")