Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to add up all cells with no fill color
Hello,
I copied a function called "CountCol" which will help me count the colored cells in my spreadsheet. I have to type the following function in my spreadsheet, =countcol(a1:a100,6), and it will count--in this case--all the cells in the range a1:a100 that have color yellow (6 stands for the color index which equals yellow). What is the color index for "no fill"? (I want to count all the cells with text which have no fill) Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add fill color in cells | Excel Discussion (Misc queries) | |||
Fill cells with color based on criteria in two cells | Excel Worksheet Functions | |||
HOW TO FORMATE CELLS TO COUNT CELLS WITH A FILL COLOR? | New Users to Excel | |||
Excel 2003 will not display color fonts or color fill cells | Excel Worksheet Functions | |||
My excel 2003 wont let me fill cells with color or color the tabs. | New Users to Excel |