Help with conditional formatting

[Cindy Like]

I am wanting to use conditional formatting for the
following scenario:
* If the employee number is for one person, then that row
would be shaded in one color.
* If the employee number is for another person, then that
row would be shaded in another color.
* This would go on for each different employee in the
database.

By the way, I am using Excel 2000. The number of
employees in this database is at 14 but I would like to
have the option to expand this if needed.

I'm wondering if this is even possible. Any help would
be greatly appreciated.

 

[Norman Harker]

Hi Cindy!

It looks like what you are after is tagging / highlighting of unique /
duplicates. Pay a visit to:

Chip Pearson:
http://www.cpearson.com/excel/duplicat.htm

Chip covers all sorts of issues to do with duplicates: Testing for,
highlighting, tagging, replacing, counting unique...

Also you might visit:

Ron de Bruin:
http://www.rondebruin.nl/Google.htm

Provides a Google Search 5.0 addin with user guide that should help in
general questions and narrowing down what you are looking for.

--
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.