Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can I count how many grey-filled cells are in a row ?
How can I return a value to a cell, that counts the number of grey filled
cells in a particular row ? ie I have rows of 12 cells, some with only 7 cells I need to count, so I fill these cells grey. However some filled cells have no value in them, but I still need to count these cells for my total. It's not the value in the cell I need, just whether or not it is color-filled. I'm not sure if this can be achieved. Thanks. |
#2
|
|||
|
|||
http://www.cpearson.com/excel/colors.htm
-- Kind Regards, Niek Otten Microsoft MVP - Excel "AnthonyG" wrote in message ... How can I return a value to a cell, that counts the number of grey filled cells in a particular row ? ie I have rows of 12 cells, some with only 7 cells I need to count, so I fill these cells grey. However some filled cells have no value in them, but I still need to count these cells for my total. It's not the value in the cell I need, just whether or not it is color-filled. I'm not sure if this can be achieved. Thanks. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I count shaded cells | Excel Worksheet Functions | |||
COUNT ONLY CELLS THAT AREN'T BLANK | Excel Worksheet Functions | |||
Count non-colored cells | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Count cells with data | New Users to Excel |