Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I count the number of gray-shaded cells within a range?
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. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I count the number of gray-shaded cells within a range?
Try this one:
http://xldynamic.com/source/xld.ColourCounter.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Gary" wrote in message ... |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. | | | | |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do I count the number of gray-shaded cells within a range?
and don't forget to copy the supplied UDF into your workbook!
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Niek Otten" wrote in message ... Try this one: http://xldynamic.com/source/xld.ColourCounter.html -- Kind regards, Niek Otten Microsoft MVP - Excel "Gary" wrote in message ... |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. | | | | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
count number of cells in range showing between 320 and 345 | Excel Worksheet Functions | |||
formula to count cells containing #'s in a specific range | Excel Worksheet Functions | |||
count number of occurances of a word in a range | Excel Worksheet Functions | |||
Convert data of cells to any type: Number, Date&Time, Text | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) |