I now know that there's no built in formula in excel to count cells with colored font and you need user designated function thru VBA to this.. I have tried the DateIndex and works like a charm in counting the cells with colored font. Can somebody suggest how to make it count colored text but with additional criteria to count only the colored txt with a specific text? Using below sample.. I want a formula to count the instances of apples in red only.
Apple
Orange
Apple
Banana
Apple
Apple
Banana
Can you attached a sample to be sure to use the right color
"DateIndex in counting the cells with colored font" can you show how you did.
- Battle without fear gives no glory - Just try
A possibility could be
Please Login or Register to view this content.
Thanks PCI.. attached is the sample.. by the way its ColorIndex :, my mistake.... I want to find a way to count the apples only besides COUNTIF which will not work on colored font hehehe.ColorIndex.xlsm
Can't we do it by entering the txt in the formula? Without referencing to a cell with the same color and txt?
What about
=SUMPRODUCT((ColorIndex(A1:B7,TRUE)=3)*(A1:B7="Apple"))
Exactly what I need, really works.. thanks a million PCI
You're welcome.
Here again how important was to send a sample file.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks