G Guest Nov 3, 2004 #1 I have a colum, filled with text in 5 different colors. How can I count the cells with text in red, green or blue ?
I have a colum, filled with text in 5 different colors. How can I count the cells with text in red, green or blue ?
C Chip Pearson Nov 3, 2004 #2 You need a VBA function to do this. See www.cpearson.com/excel/colors.htm for code and examples. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message news:[email protected]...
You need a VBA function to do this. See www.cpearson.com/excel/colors.htm for code and examples. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message news:[email protected]...
G Guest Nov 4, 2004 #3 Chip. Thanks ! Chip Pearson said: You need a VBA function to do this. See www.cpearson.com/excel/colors.htm for code and examples. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message Click to expand...
Chip. Thanks ! Chip Pearson said: You need a VBA function to do this. See www.cpearson.com/excel/colors.htm for code and examples. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com message Click to expand...
