View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default countif based on fill color

Not possible with built in functions unless you can use the criteria which
made you colour them in the first place, otherwise you will need code,
either a macro or a UDF

http://www.cpearson.com/excel/colors.htm

--
Regards,

Peo Sjoblom

Portland, Oregon




"edmcf@mot" wrote in message
...
Can anyone tell me how to do a countif based on cell fill color? I want to
count all cells I've filled in red.