View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default In Excel, how do I "Countif" a cell is a certain format?

If the colours are not conditional formats then check out this link...

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

If the colours are based on conditional formats then you can use regular
formulas...
--
HTH...

Jim Thomlinson


"Pheasants21" wrote:

If I choose a series of cells and I want to determine how many of those cells
have a fill color of Red, how many have green, etc..., can I do that?