Hi Mike H, thank you so much, I am very simple at this and have tried to copy
and paste but I have no result, if I want to copy the formula or fuction and
apply to excel where do I paste these long winded functions?

"Mike H" wrote:


Hi,

have a look here

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

Mike

"halcyon" wrote:

I would like to count the cells that have a value in font color red and not
count the cells in font color black, how can i achieve this?