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!