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?

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

--
Kind regards,

Niek Otten

"Alfred Kingfisher" <Alfred wrote in
message ...
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?

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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alfred Kingfisher" <Alfred wrote in
message ...
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?