Matching Values across worksheets

[chodges84]

Hi All,

I have a bit of a problem, I was hoping someone could give me some pointers. I've had a search through the forum, but couldn't find an exact solution (although I did get one other related problem solved.)

What I have is an Excel spreadsheet with about 9 worksheets. One for each current videogames console, e.g. nintendods, nintendowii, playstation3 etc.

Each sheet contains online merchants, such as amazon or play that sell games for that console. There is one merchant per column and in the merchants column is a list of the games for that console that they sell.

I am after some kind of script that I can run, that will look through all the values in the workbook, and search through all the other values to find any exact matching values and change the colour of both matching cells cells to red.

I have attached a cut down copy of the spreadsheet, with a few values per console and a few matching values coloured red.

Any help is greatly appreciated.

Many Thanks,
Craig