Wildcard for any number in conditional formula

[Studebaker]

Hello,

I'm trying to create a conditional formula that will highlight cell P17 if:
a) there is a number (any number) in cell J17 AND
b) there is a blank cell in O17

Using "Formula Is", I typed:

=AND(J17=*,O17="""")

J17 & O17 are numbers of any length--ex: 2,282.08 or 13.78 or 100,456.07--to
represent invoice totals (they are custom #s).

It's not working. I don't know if the 'AND' function is wrong or if it's the
wildcard * I used to look for any number in J17. I tried the wildcard, # and
[0-9], instead and they didn't work either.

T. Valko's 2/14/08 post said that wildcards don't work for numbers but a
website I went to said that any of those wildcards would work to find any
numbers. This site was talking about it in the context of Find and Replace so
maybe wildcards don't work the same in formulas (?).

Can someone help?

Thank you.

 

[David Biddulph]

=AND(ISNUMBER(J17),O17="")

 

[Pete_UK]

Try this for your formula:

=AND(ISNUMBER(J17),O17="")

Hope this helps.

Pete

 

[Studebaker]

Thank you and David, both. It worked!

Try this for your formula:

=AND(ISNUMBER(J17),O17="")

Hope this helps.

Pete

Hello,

I'm trying to create a conditional formula that will highlight cell P17 if:
a) there is a number (any number) in cell J17 AND
b) there is a blank cell in O17

Using "Formula Is", I typed:

=AND(J17=*,O17="""")

J17 & O17 are numbers of any length--ex: 2,282.08 or 13.78 or 100,456.07--to
represent invoice totals (they are custom #s).

It's not working. I don't know if the 'AND' function is wrong or if it's the
wildcard * I used to look for any number in J17. I tried the wildcard, # and
[0-9], instead and they didn't work either.

T. Valko's 2/14/08 post said that wildcards don't work for numbers but a
website I went to said that any of those wildcards would work to find any
numbers. This site was talking about it in the context of Find and Replace so
maybe wildcards don't work the same in formulas (?).

Can someone help?

Thank you.

 

[Pete_UK]

You're welcome - thanks for feeding back.

Pete

Thank you and David, both. It worked!

Try this for your formula:

=AND(ISNUMBER(J17),O17="")

Hope this helps.

Pete

Hello,
I'm trying to create a conditional formula that will highlight cell P17 if:
a) there is a number (any number) in cell J17 AND
b) there is a blank cell in O17
Using "Formula Is", I typed:
=AND(J17=*,O17="""")
J17 & O17 are numbers of any length--ex: 2,282.08 or 13.78 or 100,456.07--to
represent invoice totals (they are custom #s).
It's not working. I don't know if the 'AND' function is wrong or if it's the
wildcard * I used to look for any number in J17. I tried the wildcard,# and
[0-9], instead and they didn't work either.
T. Valko's 2/14/08 post said that wildcards don't work for numbers buta
website I went to said that any of those wildcards would work to find any
numbers. This site was talking about it in the context of Find and Replace so
maybe wildcards don't work the same in formulas (?).
Can someone help?
Thank you.- Hide quoted text -

- Show quoted text -