Thanks for the repsonse, not being an expert on vb can anyone assist with the
code then im assuming if I have more than 1 checkbox relating to different
ranges id need the code for each one ?

Cheers

D


Nayab wrote:
Dear All

[quoted text clipped - 7 lines]
--
Message posted via OfficeKB.comhttp://www.officekb.com/Uwe/Forums.aspx/ms-excel/200806/1

I think u can do it via Vb. U can check if the checkbox ischecked.
then u can format the range and specify the color

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1