View Single Post
  #4   Report Post  
Randy
 
Posts: n/a
Default

Thanks,

i looked at that but had trouble when I put the counting formula into my
cell. It returns a #NAME? error.

My cells are in row a7:z7

so i modifed the forumal to read

=SUMPRODUCT(--(ColorIndex(C7:Z7)=3))

I am not sure that the -- mean before the second (. I do not remeber seeing
these before.

Any suggestions?


"Paul B" wrote:

Randy, have a look here

http://www.cpearson.com/excel/colors.htm
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003

"Randy" wrote in message
...
I have built a scheduling templet and would like to be able to count the
number of cells that shaded. Where shaded cells represent hours worked.
Any
ideas?