Thread: Is there a way to count the number of different colored cells?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jim Cone Jim Cone is offline
external usenet poster
  
Posts: 3,290
Default Is there a way to count the number of different colored cells?
You will have to use code; Chip Pearson show how...
http://www.cpearson.com/excel/colors.htm
--
Jim Cone
San Francisco, USA
http://www.officeletter.com/blink/specialsort.html



"MCM"
wrote in message
I have uniqure colored rows in my excell spreadsheet. Is there a formula to
count the total number of green rows, red rows, blue rows, etc?
Reply With QuoteReply With Quote