Conditional formatting with text search
 

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!

Conditional formatting with text search
 

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!

Conditional formatting with text search
 

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!

Conditional formatting with text search
 

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!

Conditional formatting with text search
 

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!

Conditional formatting with text search
 

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!

Conditional formatting with text search
 

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" wrote:

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!

Conditional formatting with text search
 

Oh well!

--
Biff
Microsoft Excel MVP


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

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!