Sure thing, add one (or both) of these lines:


Range("B1:G1").Interior.ColorIndex = xlNone 'clears background
color
Range("B1:G1").Font.ColorIndex = 0 'set font color to Automatic

Your request seems pretty straight-forward to me.

alex1982 wrote:
A1 is a drop down menu with 2 choice. when nothing is selected i want to
be able to choose the cell colours of B1-G1 myself. as i have a macro to
count cells by cell colour. However, when one of these options is
selected i want it to delete all the cell info and colours from B1-G1.


--
alex1982
------------------------------------------------------------------------
alex1982's Profile: http://www.excelforum.com/member.php...o&userid=37494
View this thread: http://www.excelforum.com/showthread...hreadid=573248