View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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