You need to use a custom function to return the colour of the cell, you can
find the function and also some examples on counting in this link:
http://www.cpearson.com/excel/colors.htm

Hope this helps,
Miguel

"Fecozisk" wrote:

Hi everyone!
I'd like to use contif not just for counting how many times a number
appears, but also for conting how many times the number 5 appeared in red,
for example.

I'd like to use five different colors

thanks everyone!

ps: i'm sorry, but im new user! please be patient and teach me step by
step!! Thanks a lot!

Fernando