Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
I have used Conditional Formatting present in the Format Menu to
highlight cells in the worksheet with satisfy the condition. Now I want to count the total number of cells highlighted by conditional formattin for each column and display in a cell of the column... Kindly help me with a way to do this...I tried using the interior.colorindex property to count the cells coloured ... but no use because conditional formattin doesnot actually change the cell's formatting it just highlight... Plzzz let me kno how to do.. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
divya, may be easier to just count what conditional formatting is looking
at, something like =COUNTIF(A2:A25,"test") If you do need to count conditional formatting color have a look at Chip Pearson's page here http://www.cpearson.com/excel/CFColors.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "divya" wrote in message ups.com... I have used Conditional Formatting present in the Format Menu to highlight cells in the worksheet with satisfy the condition. Now I want to count the total number of cells highlighted by conditional formattin for each column and display in a cell of the column... Kindly help me with a way to do this...I tried using the interior.colorindex property to count the cells coloured ... but no use because conditional formattin doesnot actually change the cell's formatting it just highlight... Plzzz let me kno how to do.. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
Paul B wrote: divya, may be easier to just count what conditional formatting is looking at, something like =COUNTIF(A2:A25,"test") If you do need to count conditional formatting color have a look at Chip Pearson's page here http://www.cpearson.com/excel/CFColors.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "divya" wrote in message ups.com... I have used Conditional Formatting present in the Format Menu to highlight cells in the worksheet with satisfy the condition. Now I want to count the total number of cells highlighted by conditional formattin for each column and display in a cell of the column... Kindly help me with a way to do this...I tried using the interior.colorindex property to count the cells coloured ... but no use because conditional formattin doesnot actually change the cell's formatting it just highlight... Plzzz let me kno how to do.. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
How to count the number of cells highlighted using Conditional Formatting feature present in Format Menu of Excel???
thnk you paul for hte link...
Paul B wrote: divya, may be easier to just count what conditional formatting is looking at, something like =COUNTIF(A2:A25,"test") If you do need to count conditional formatting color have a look at Chip Pearson's page here http://www.cpearson.com/excel/CFColors.htm -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "divya" wrote in message ups.com... I have used Conditional Formatting present in the Format Menu to highlight cells in the worksheet with satisfy the condition. Now I want to count the total number of cells highlighted by conditional formattin for each column and display in a cell of the column... Kindly help me with a way to do this...I tried using the interior.colorindex property to count the cells coloured ... but no use because conditional formattin doesnot actually change the cell's formatting it just highlight... Plzzz let me kno how to do.. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to count cells that are highlighted by conditional formatting | Excel Worksheet Functions | |||
how to count number of highlighted cells in column | Excel Discussion (Misc queries) | |||
Excel should return feature of highlighted cells as totals | Excel Worksheet Functions | |||
Count number of cells that are highlighted | Excel Programming | |||
Is there a way to count the number of highlighted cells in a col? | Excel Discussion (Misc queries) |