CountIf --- for colours
 

Is it possible to use a countif for a cell that's say, RED. I'm just using
the standard red fill. I have other colours that I want to count, but if I
start with one, I can maybe move on to others.

I'm using a countif for a cell with certain text, but now I want to try a
fill colour. Is this an option and if so, how do I denote that I want it to
recognize a colour ... and that colour is red.

I hope I explained this properly.
Thanks.

CountIf --- for colours
 

The answer will be found on Chips's site:
http://www.cpearson.com/excel/colors.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cowtoon" wrote in message
...
Is it possible to use a countif for a cell that's say, RED. I'm just
using
the standard red fill. I have other colours that I want to count, but if
I
start with one, I can maybe move on to others.

I'm using a countif for a cell with certain text, but now I want to try a
fill colour. Is this an option and if so, how do I denote that I want it
to
recognize a colour ... and that colour is red.

I hope I explained this properly.
Thanks.

CountIf --- for colours
 

Thanks Bernard.
That's a little out of my league. I think it'll be easier to manully count
the cells.
I appreciate the lead.

"Bernard Liengme" wrote in message
...
The answer will be found on Chips's site:
http://www.cpearson.com/excel/colors.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cowtoon" wrote in message
...
Is it possible to use a countif for a cell that's say, RED. I'm just
using
the standard red fill. I have other colours that I want to count, but if
I
start with one, I can maybe move on to others.

I'm using a countif for a cell with certain text, but now I want to try a
fill colour. Is this an option and if so, how do I denote that I want it
to
recognize a colour ... and that colour is red.

I hope I explained this properly.
Thanks.

CountIf --- for colours
 

New Year's resolution for you:
"I will try to learn VBA "
<grin
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cowtoon" wrote in message
...
Thanks Bernard.
That's a little out of my league. I think it'll be easier to manully
count
the cells.
I appreciate the lead.

"Bernard Liengme" wrote in message
...
The answer will be found on Chips's site:
http://www.cpearson.com/excel/colors.htm
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Cowtoon" wrote in message
...
Is it possible to use a countif for a cell that's say, RED. I'm just
using
the standard red fill. I have other colours that I want to count, but if
I
start with one, I can maybe move on to others.

I'm using a countif for a cell with certain text, but now I want to try a
fill colour. Is this an option and if so, how do I denote that I want it
to
recognize a colour ... and that colour is red.

I hope I explained this properly.
Thanks.