Format menu - conditionally formatting.
Should require a bit of playing but you'll get there.
You might need a cell which compares the data and gives you a 1 if it's
the same or a 0 if it's not, then do conditional formatting on that, I
don't know. But you'll get there :)
--
gearoi
------------------------------------------------------------------------
gearoi's Profile:
http://www.excelforum.com/member.php...o&userid=26576
View this thread:
http://www.excelforum.com/showthread...hreadid=401923