Count colored cells

student · Aug 18, 2004

Suppose if i have some colored cells in a coloumn. Is there any formula to
count the colored cells. Is it possible without vb code.

Thanks

Frank Kabel · Aug 18, 2004

Hi
not possible without VBA. For a VBA solutuion see:
http://www.xldynamic.com/source/xld.ColourCounter.html