Can you regonise a coloured cell in a formula?
 

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.

--
Jim

Can you regonise a coloured cell in a formula?
 

Hi
Yes you can see CPearson web

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

if this helps please click yes thanks

"Jim" wrote:

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.

--
Jim

Can you regonise a coloured cell in a formula?
 

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

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Jim" wrote in message
...
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.

--
Jim