Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting CF cells
Dear friends,
i've inserted modules from http://www.cpearson.com/excel/CFColors.htm, however i failed to get any of the function working - even =ColorOfCF(A1,FALSE). and i hope to gain support from you. i am using excel 2007. cells were formatted on conditions using the conditioning format button available at the top panel (under home tab). will that be a problem? there're more than a thousand rows and not all of them are formatted under the same condition. my goal is to count the cells of the same color, i guess i have to use =CountOfCF(..) look forward to your reply. best regards, maggie |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting CF cells
On Jul 15, 5:04*am, Maggie Lau wrote:
Dear friends, i've inserted modules fromhttp://www.cpearson.com/excel/CFColors.htm, however i failed to get any of the function working - even =ColorOfCF(A1,FALSE). and i hope to gain support from you. i am using excel 2007. cells were formatted on conditions using the conditioning format button available at the top panel (under home tab). will that be a problem? there're more than a thousand rows and not all of them are formatted under the same condition. my goal is to count the cells of the same color, i guess i have to use =CountOfCF(..) look forward to your reply. best regards, maggie What happens when you try to use the functions? Do you see: #NAME? or Do you see an incorrect value? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting CF cells
On Jul 15, 10:42*pm, James Ravenswood
wrote: On Jul 15, 5:04*am, Maggie Lau wrote: Dear friends, i've inserted modules fromhttp://www.cpearson.com/excel/CFColors.htm, however i failed to get any of the function working - even =ColorOfCF(A1,FALSE). and i hope to gain support from you. i am using excel 2007. cells were formatted on conditions using the conditioning format button available at the top panel (under home tab). will that be a problem? there're more than a thousand rows and not all of them are formatted under the same condition. my goal is to count the cells of the same color, i guess i have to use =CountOfCF(..) look forward to your reply. best regards, maggie What happens when you try to use the functions? Do you see: *#NAME? or Do you see an incorrect value? thanks for your reply. "#NAME" always appeared, probably i was not using the function correctly? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting the number of cells between 2 seperate cells | Excel Discussion (Misc queries) | |||
Query counting cells in a row that exactly match cells in another | Excel Discussion (Misc queries) | |||
Complicated counting of cells (based on other cells contents) | Excel Worksheet Functions | |||
Counting empty cells within a range of cells | New Users to Excel | |||
Counting empty cells within a range of cells | New Users to Excel |