View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fecozisk
 
Posts: n/a
Default problem not solved... CONT.IF depending on the text color

I have a table (A1:A100) with numbers from 1 to 50 with three different colors

In cell B1:
i´d like to COUNT how many times the number 10 apears in RED

In cell B2:
i´d like to COUNT how many times the number 10 apears in BLUE

In cell B3:
i´d like to COUNT how many times the number 10 apears in GREEN

im a new user, so i couldnt make work with the solution suggested in my last
topic... a guy suggested the site
http://www.xldynamic.com/source/xld.ColourCounter.html
I apreciate everyone´s help! Please teach me step by step! thanks again!