How can I tell a formula from a number?

Is there an excel function that can distinguish between a number and a formula?

A cell contains a default formula, but this can be overridden with a specific number.

I want to set up a conditional format rule to change the cell color when a number is typed over the formula.

Thanks

I hope this is clear,

1.- Select Cell A1
2.- Create a name called IsFormula
3.- In the Refer to: box type this =GET.CELL(48,!A1)
4.- Select the cells where you want the conditional formating
5.- Select Use a formula to determine which cells to format
6.- In the Format values where this formula is true box type =IsFormula
7.- Select the format you want to use.


Regards

Originally Posted by davesexcel

The OP wants to Highlight the cells that are not a Formula.

Then use =IsFormula=FALSE for the condition.

Example attached.

Regards

Originally Posted by davesexcel

Why would I be told the workbook has Macro4, in it?

Because Get.Cell is part of the old XLM Excel macros functions.

Originally Posted by davesexcel

when I changed the formula cells to a simple number nothing changed

Press Page Down once when you open book, back to A1, then play with cells with CF.

Regards

Originally Posted by davesexcel

Nope, I won't do that, I will not do anything with XLM Excel macros, and don't expect anybody else to either...

What is the problem with them? I have seen some DonkeOte's answers using them. If I'm not wrong they are now incorporated in VBA Office 2010.

Regards

Originally Posted by davesexcel

Where in the post with your attachment does it say, "Press Page Down once when you open book, back to A1, then play with cells with CF."?

It's just to calculate the formula once, it will be the same if you press F9.

Regards