Formula to count the cells in a range that have a fill color.

[Slainteva]

I'm just trying to create a formula in a cell that will count the cells in a
range that don't have a "nil" fill color.

 

[Jason Morin]

See:

http://www.xldynamic.com/source/xld.ColourCounter.html

HTH
Jason
Atlanta, GA