View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Y Y is offline
external usenet poster
 
Posts: 2
Default how do I count the number of gray-shaded cells within a range?

I want to use the format of the cell (font color, shading color, etc.) as a
criterium in a countif formula. How do I do it? what's the syntax for that.
thanks.