Excel help- conditional formatting or other suggestions

[katie2012]

Hello,

I am working on a project in Excel where I have 10 different tables of categories. would like a way to see what data is also in the other categories and also which specific category. I was hoping I could conditionally format each line of data with a different color by category, but all I have been able to do is highlight all the duplicates. For example, I have line 5 which is in category a, b, and c. Is there anyway I can easily see that line 5 belong to all categories? I tried a pivot table but this didnt really give me the view I was hoping for.

 

[mintjulep]

And something being in a category is known how?

 

[katie2012]

The data in the categories are just names I manually entered into a table.

 

[SkipVought]

hi,

This piques my interest...

10 different tables of categories

What are these 10 tables? Examples please.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[katie2012]

Its work related so I'm not able to release specifics but here is how the tables are set up:
Category A # Location
Name1
Name2
Name3
Name4
Name5
Name6
Name7
Name8
Name9
Name10
Name11
Name12
Name13
Name14
Name15
Name16
Name17
Name18
Name19
Name20

 

[SkipVought]

So you also have a Category B table and a Category C table and so on?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

If that's the case then you ought to have ONE table like...
[tt]
category name #. location

[/tt]

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}