isformula?

[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

 

[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

 

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

 

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

 

[Gord Dibben]

dave

Not without VBA.

See Bob's answer for UDF.


Gord Dibben Excel MVP

 

[dave]

thanks! Isuppose a UDF is still pretty easy as opposed to
writing code every time

 

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

 

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

 

[Don Guillett]

in the CF>formula=isformula(c5)>format as desired

 

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





.

 

[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