thanks for this Bruce

row 1 - )cell a)we 19th August 2005
row 2 - (cell a) Tracy Toal - (cell b) Micky Mouse - (cell c) Donald
Duck
row 3 - (cell a) we 26th August
row 4 - (cell a) Tracy Toal - (cell b) Pluto

I want cell a of row 4 to be orange so that is show Tracy Toal appears
in row 2 and 4

hope this makes sense


--
tracyt620
------------------------------------------------------------------------
tracyt620's Profile: http://www.excelforum.com/member.php...fo&userid=5554
View this thread: http://www.excelforum.com/showthread...hreadid=398562