Can you regonise a coloured cell in a formula?

  • Thread starter Thread starter Jim
  • Start date Start date
J

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.
 
sub checkcolor()' put in your desired color number
if activecell.interior.colorindex=6 then msgbox "c"
end sub
 
Back
Top