Conditional Formatting and ISFORMULA in 2010

[brumby]

Hiya folks,

I am trying to highlight any cells in my range which are not formula's. It looks like ISFORMULA is not part of 2010, is there any other ways?

Many Thanks

 

[T. Valko]

See this...

http://tinyurl.com/CellHasFormula

That describes how to apply cf to cells that DO contain formulas.

Since your application is the exact opposite you'd want to use the formula:

=NOT(IsFormula)

Or:

=IsFormula=FALSE