Conditional formatting with text search

[Ed]

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!

 

[T. Valko]

Need *specific details*.

 

[Ed]

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]

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.

 

[Ed]

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

 

[T. Valko]

Try this:

Select the range D2100
Goto the menu Format>Conditional 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$100=D2))>1

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

 

[Ed]

Darn! That didn't work for some reason. I tried breaking it and using only
the section that searched for "microsoft office" but I couldn't get that to
highlight either...This is a clunky way to store this information anyway, I
think I'm going to just make an access database out of it. I really
appreciate you trying to help me.
-Ed

 

[T. Valko]

Oh well!

--
Biff
Microsoft Excel MVP

Darn! That didn't work for some reason. I tried breaking it and using only
the section that searched for "microsoft office" but I couldn't get that
to
highlight either...This is a clunky way to store this information anyway,
I
think I'm going to just make an access database out of it. I really
appreciate you trying to help me.
-Ed