View Single Post
  #1  
Old June 2nd, 2010, 02:54 PM posted to microsoft.public.excel.worksheet.functions
AOdoc
external usenet poster
 
Posts: 1
Default Counting cells with conditional formatting

I am trying to count the cells in a range that have a certain fill color in
Excel 2003. Is there a way to use COUNTIF? If so, how do I write the criteria
for the color I'm looking for? Or, is there another formula? Many thanks to
whomever can answer this one!