isformula?

D

dave

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
 
R

RagDyeR

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!
==============================================


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
 
D

dave

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.
 
B

Bob Phillips

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)
 
D

dave

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?
 
B

Bob Phillips

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)
 
D

dave

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)





.
Click to expand...
 
C

CLR

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
 
Top