Versions earlier than 2003 do not have this function.

Also, if the cells are colored due to Conditional Formatting it won't work.


Gord Dibben MS Excel MVP

On Fri, 7 Dec 2007 10:48:41 -0800 (PST), Herbert Seidenberg
wrote:

No VBA or color number required:
Edit Find Find what: clear it if filled
Options Format.. Choose Format from Cell
Click any red cell Find All
The number of cells will appear in the lower left
corner of the Find window.