Locating cells with same information

I am wanting to find a way that will check a series of cells in a column that has the same information in it.

For example:

Lets presume Cell A1 has CAHL12 - HJL in it (CAHL is a subject name and HJL is a teachers initials).
There will be a series of different subjects and teachers names in the same format below it, say from A2 through to A10.

Now suppose I copy a block of other subjects with accompanying teachers initials to column A from A12 through to A 20.

The subject name I am not concerned with but the teachers initails is what I am searching for.

I am wanting to determine if the teacher has already been placed in the column above by searching for identical initials.

If the formula determines that this is true then I would ideally like to highlight the cells where the teacher initials match within the column.

I hope that someone can help me with this problem.

Thankyou for your very quick response to my problem.

I successfully placed the macro into the program which ran successfully yesterday but it has encountered an error today.
I am certain it is my inadequate ability to use it correctly and not your programming prowess.

When it did work I found that the column where the doubled teacher name appeared was highlighted instead of just the cell.

I will try another tactic by placing the satff initials into separate columns next to the subject name and try a search for doubled up names.

A much less acceptable way of doing things but will eventually do the job for me.

I just like to think that with the press of a button the computer will do the job for me automatically.

Thanks again for your assistance.

It is very difficult to program effectively without a good set of test data that covers lots of different scenario. Don't give up yet. If you want to send me the file that caused the error (private message), I would happily have a look at it for you.

Matt

Matt,
Thankyou for your offer of assistance.
I would like to send to you part of the excel spreadsheet so you can see what I am dealing with but I do not know how this can be done.

Greg

Just zip it up, and then attach it to a post. Then send me a Private message so I know to find it