Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIf function query
Hi,
Is it possible to use the CountIF function to return the number of cells in a specific range which have a particular interior colour regardless of the value content of the cell? If so what information should be used in the 'Criteria' section of the function wizard? I have tried putting in .Interior.ClourIndex = 6 but this does not do anything |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIf function query
It is not possible without a custom function. See
www.cpearson.com/excel/colors.htm for details and example code. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "Alan M" wrote in message ... Hi, Is it possible to use the CountIF function to return the number of cells in a specific range which have a particular interior colour regardless of the value content of the cell? If so what information should be used in the 'Criteria' section of the function wizard? I have tried putting in .Interior.ClourIndex = 6 but this does not do anything |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
CountIf function query
See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution -- HTH Bob Phillips (remove nothere from email address if mailing direct) "Alan M" wrote in message ... Hi, Is it possible to use the CountIF function to return the number of cells in a specific range which have a particular interior colour regardless of the value content of the cell? If so what information should be used in the 'Criteria' section of the function wizard? I have tried putting in .Interior.ClourIndex = 6 but this does not do anything |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Countif query | Excel Worksheet Functions | |||
Mutliple Function Query - probably using Countif | Excel Worksheet Functions | |||
COUNTIF function query | Excel Worksheet Functions | |||
COUNTIF function query for multiple colums | Excel Worksheet Functions | |||
Microsoft Query rejects "nz" function in Access Query | Excel Discussion (Misc queries) |