Thanks for your reply.

I have drop downs linked from C4 to C12, For some reason, the cod
doesn't change any of the formatting when I change the drop dow
value.

Any ideas?

Thanks

--
Matt_2
-----------------------------------------------------------------------
Matt_2K's Profile: http://www.excelforum.com/member.php...nfo&userid=617
View this thread: http://www.excelforum.com/showthread.php?threadid=48102