G Guest Oct 17, 2007 #1 I want to use a formula to count the number of cells in a range that are highlighted a certain color. Is this possible?
I want to use a formula to count the number of cells in a range that are highlighted a certain color. Is this possible?
P Peo Sjoblom Oct 17, 2007 #3 If you have Excel 2007 you can filter by colour and the count it using SUBTOTAL(3,Full_Range) In earlier versions you would need VBA http://www.cpearson.com/excel/colors.htm http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards, Peo Sjoblom
If you have Excel 2007 you can filter by colour and the count it using SUBTOTAL(3,Full_Range) In earlier versions you would need VBA http://www.cpearson.com/excel/colors.htm http://www.xldynamic.com/source/xld.ColourCounter.html -- Regards, Peo Sjoblom
