Can you regonise a coloured cell in a formula?

[Jim]

In Excel 2007 i am trying to find a formula that would be able to regonise if
a cell was shaded in a paticualar colour, green and purple, and count how
many there were for a specific month.
The coloured cells are in cloumn 2 and the month number is in column AO.

Is this possible?

Thanks for any assistance offered.

 

[Eduardo]

Hi
Yes you can see CPearson web

http://www.cpearson.com/excel/colors.aspx

if this helps please click yes thanks

 

[Don Guillett]

sub checkcolor()' put in your desired color number
if activecell.interior.colorindex=6 then msgbox "c"
end sub