Hi Dave.........

You seem somewhat tentative.........did you get this working for you
application? Bob's UDF suggestion really does work fine once you put the
code in a regular module and then use the "formula" in the CF "Formula is"
window.........if you're still having trouble, send me your workbook at my
HOME addy and I will install it for you..........

Vaya con Dios,
Chuck, CABGx3


"dave" wrote in message
...
thanks again
-----Original Message-----
select the cells, assume A1 is the first, and in CF add a
formula of

=IsFormula(A1)

--

HTH

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


"dave" wrote in message
...
I've added the code - and I'm trying to make the CF work.
I'm using cell value is equal to =Isformula=true, but it
doesn't seem to work. what am I doing wrong?
-----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


.



.



.