| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Formula to count the cells in a range that have a fill color.
I'm just trying to create a formula in a cell that will count the cells in a
range that don't have a "nil" fill color. |
|
#2
|
|||
|
|||
|
Molly F wrote:
I'm just trying to create a formula in a cell that will count the cells in a range that don't have a "nil" fill color. I think you can only do that with a VB script....... -- gordonATgbpcomputingDOTcoDOTuk To email me replace the obvious! |
|
#3
|
|||
|
|||
|
http://www.cpearson.com/excel/colors.htm
-- Kind Regards, Niek Otten Microsoft MVP - Excel "Molly F" <Molly wrote in message ... I'm just trying to create a formula in a cell that will count the cells in a range that don't have a "nil" fill color. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Count non-colored cells | Excel Discussion (Misc queries) | |||
| Count number of shaded cells | Excel Discussion (Misc queries) | |||
| Identifying the Active Fill Color | Excel Discussion (Misc queries) | |||
| Using color to ignore cells in a formula????? | Excel Discussion (Misc queries) | |||
Linear Mode
