Is there an Excel formula to sum color filled cells?

[Guest]

I have an Excel (2003) worksheet where cells are either color filled or not.
Is there a formula that I can use to calculate the current number of cells
that have no color fill?

 

[Niek Otten]

http://www.cpearson.com/excel/colors.htm

 

[prabhuraaman]

There is no direct way.But there is an indirect way if you are using
Microsoft Excel 2003

CLIK CTRL+F
CLIK OPTIONS
GO TO THE FORMAT BOX AND SELECT THE CELL HAVING YOUR FORMAT AND CLIK
FIND ALL
When the results are displayed,Select ALL THE RESULTS.
The sum would be highlighted in the STATUS BAR

For more join
http://groups.google.co.in/group/Answers-for-everything

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)