Hi, I am trying to make a conditional format that would highlight duplicate
items in colum D if certain text exists in column B. I would like to use a
wildcard for text items in column B...Any sugggestions would be great!

Need *specific details*.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Hi, I am trying to make a conditional format that would highlight
duplicate
items in colum D if certain text exists in column B. I would like to use a
wildcard for text items in column B...Any sugggestions would be great!

Sorry, should have included this with original post...What I have is a huge
list of PC's by name and apps/product keys. What I am trying to go for is to
conditionally format the product keys to display duplicates, but only for MS
Office products. I also have several different versions of office, that's why
I wanted to include a wildcard.

"T. Valko" wrote:

Need *specific details*.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Hi, I am trying to make a conditional format that would highlight
duplicate
items in colum D if certain text exists in column B. I would like to use a
wildcard for text items in column B...Any sugggestions would be great!

That's not as specific as I would like!

How about something like this:

I have a list of software apps in the range B1:B100 and the corresponding
product keys in the range C2:C100.

I want to use conditional formatting to identify duplicate product codes for
apps that contain the word Microsoft.

If you can provide that kind of specific info I'm sure we can come up with a
solution.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Sorry, should have included this with original post...What I have is a
huge
list of PC's by name and apps/product keys. What I am trying to go for is
to
conditionally format the product keys to display duplicates, but only for
MS
Office products. I also have several different versions of office, that's
why
I wanted to include a wildcard.

"T. Valko" wrote:

Need *specific details*.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Hi, I am trying to make a conditional format that would highlight
duplicate
items in colum D if certain text exists in column B. I would like to
use a
wildcard for text items in column B...Any sugggestions would be great!

OK, so I have a list of product keys in range D2:D100. I have a list of apps
in range B2:B100. I would like to show duplicates in product keys(D2:D100)
but only if the text "microsoft office" is in range B2:B100.

"T. Valko" wrote:

That's not as specific as I would like!

How about something like this:

I have a list of software apps in the range B1:B100 and the corresponding
product keys in the range C2:C100.

I want to use conditional formatting to identify duplicate product codes for
apps that contain the word Microsoft.

If you can provide that kind of specific info I'm sure we can come up with a
solution.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Sorry, should have included this with original post...What I have is a
huge
list of PC's by name and apps/product keys. What I am trying to go for is
to
conditionally format the product keys to display duplicates, but only for
MS
Office products. I also have several different versions of office, that's
why
I wanted to include a wildcard.

"T. Valko" wrote:

Need *specific details*.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Hi, I am trying to make a conditional format that would highlight
duplicate
items in colum D if certain text exists in column B. I would like to
use a
wildcard for text items in column B...Any sugggestions would be great!

Try this:

Select the range D2:D100
Goto the menu FormatConditional Formatting
Select the Formula Is option
Enter this formula in the box on the right:

=SUMPRODUCT(--(ISNUMBER(SEARCH("microsoft
office",B$2:B$100))),--(D$2:D$100=D2))1

Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
OK, so I have a list of product keys in range D2:D100. I have a list of
apps
in range B2:B100. I would like to show duplicates in product keys(D2:D100)
but only if the text "microsoft office" is in range B2:B100.

"T. Valko" wrote:

That's not as specific as I would like!

How about something like this:

I have a list of software apps in the range B1:B100 and the corresponding
product keys in the range C2:C100.

I want to use conditional formatting to identify duplicate product codes
for
apps that contain the word Microsoft.

If you can provide that kind of specific info I'm sure we can come up
with a
solution.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Sorry, should have included this with original post...What I have is a
huge
list of PC's by name and apps/product keys. What I am trying to go for
is
to
conditionally format the product keys to display duplicates, but only
for
MS
Office products. I also have several different versions of office,
that's
why
I wanted to include a wildcard.

"T. Valko" wrote:

Need *specific details*.

--
Biff
Microsoft Excel MVP


"Ed" wrote in message
...
Hi, I am trying to make a conditional format that would highlight
duplicate
items in colum D if certain text exists in column B. I would like to
use a
wildcard for text items in column B...Any sugggestions would be
great!