View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AOdoc AOdoc is offline
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!