thanks! Isuppose a UDF is still pretty easy as opposed to
writing code every time
-----Original Message-----
Dave,

Create a UDF and use that in the CF formula

Function IsFormula(rng As Range)
IsFormula = rng.HasFormula
End Function


--

HTH

RP
(remove nothere from the email address if mailing direct)


"dave" wrote in message
...
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


.



.