dave

Not without VBA.

See Bob's answer for UDF.


Gord Dibben Excel MVP

On Sat, 26 Mar 2005 14:03:01 -0800, "dave"
wrote:

I'd still like to find out how it can be done via
conditional formatting, but I'll use your method until I
find out - thanks.
-----Original Message-----
Does this help?

Hit <F5, and click on <Special.

Then click on "Constants", then <OK.

This selects all your non-formula cells.

While they're all selected, you could color them if you wish.

You could also go the "other " way, and select the formulas.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all
may benefit!
==============================================


"dave" wrote in message
...
isn't there a way to point at a cell and ask whether it is
a number vs a formula. I'd like to use conditional
formatting and have formatting applied to any cell which is
a number and NOT a formula.

But ISNUMBER returns true if the RESULT is a number, not
the input. So for ex: if a1 says =a2+a3 and b1 is 3, I'd
like the result to be false fora1 and true for b1? Is this
possible without VB?

tia,
Dave


.