Thread: In Excel, how do I count cells with a particular format (e.g. colo
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten Niek Otten is offline
external usenet poster
  
Posts: 3,440
Default In Excel, how do I count cells with a particular format (e.g. colo
Look he

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"voyagerff" wrote in message ...
|I inherited a large spreadsheet with certain rows colored red. I want to be
| able to count the red rows (or cells).
| Is there some function that can test for a cell's formats? Or is there some
| technique using macros?
| Thanks in advance.


Reply With QuoteReply With Quote