View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Studebaker Studebaker is offline
external usenet poster
 
Posts: 57
Default How to add up all cells with no fill color

Hello,

I copied a function called "CountCol" which will help me count the colored
cells in my spreadsheet. I have to type the following function in my
spreadsheet,
=countcol(a1:a100,6), and it will count--in this case--all the cells in the
range a1:a100 that have color yellow (6 stands for the color index which
equals yellow).

What is the color index for "no fill"?
(I want to count all the cells with text which have no fill)

Thanks for your help!