Wildcard for any number in conditional formula
 

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.

Wildcard for any number in conditional formula
 

=AND(ISNUMBER(J17),O17="")
--
David Biddulph

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

Wildcard for any number in conditional formula
 

Try this for your formula:

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

Hope this helps.

Pete

On Apr 7, 11:01*pm, Studebaker
wrote:
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.

Wildcard for any number in conditional formula
 

Thank you and David, both. It worked!

"Pete_UK" wrote:

Try this for your formula:

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

Hope this helps.

Pete

On Apr 7, 11:01 pm, Studebaker
wrote:
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.

Wildcard for any number in conditional formula
 

You're welcome - thanks for feeding back.

Pete

On Apr 8, 2:28*pm, Studebaker
wrote:
Thank you and David, both. It worked!



"Pete_UK" wrote:
Try this for your formula:

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

Hope this helps.

Pete

On Apr 7, 11:01 pm, Studebaker
wrote:
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.- Hide quoted text -

- Show quoted text -