View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernard Liengme Bernard Liengme is offline
external usenet poster
 
Posts: 4,393
Default 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.