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.