If your using data validation with the list option to produce the dropdown,
then you can use the worksheet change event in versions of excel after xl97.
I am not sure I understand you requirement, so you may want to elaborate with
some specifics.

If you are producing your colours with Conditional formatting, it is
unlikely a function will be able to count cells based on the visual
appearance of the color since the actual colorindex of the cell is not
changed by conditional formatting.

--
Regards,
Tom Ogilvy


"alex1982" wrote:


I have a macro up and running that counts the colour of cells. I have
added a drop down menu which when one of the options is selected it
turns the whole row grey. However, my macro still counts the colours
that were orginalling in the drop down menu before anything was
selected. Is there a macro that will clear a row of cells when
something from the drop down menu is selected?


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