How to detect a formula in a cell

Hi everybody,

I would need to be able to identify (in a formula) if a given cell contains a formula or a "hard-coded" number.
(The final aim is to have a conditional formatting for the background color of this cell).

Of course, I can't use ISNUMBER as the result of the formula might be a number as well...

Thanks in advance for any good advice!

Originally Posted by sweep

Hi,

you could do

Edit > Go to> Special> Formulas

Thanks Dave, but what I try to achieve, with a conditional formatting, is to have the background of a cell, let's say, in red if the cell contains a hard-coded number, and in blue if it contains a formula.

By default all the cells would contain formula (they will thus be in blue). As soon as the user scratches a formula with a hard-coded number, then the cell gets red.

Question still open!

Originally Posted by dominicb

Good afternoon mikop

OK, put this function in an ordinary code module :

Please Login or Register  to view this content.

Then go to the cell you want to check and select Format > Conditional Formatting, select FormulaIa and use this formula (assuming cell A1) :

=IsAFormula($A$1)=TRUE

and select your format.

HTH

DominicB

Hello DominicB,

Thanks very much! It works (of course).

I should definitely invest some time in learning to program instead of struggling all the time with my poor set of Excel functions!

Have a very nice day