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

I tried what is mentioned on this site but its giving me a #NAME error.

"Niek Otten" wrote in message
...
http://www.cpearson.com/excel/colors.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Y" wrote in message
...
|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.