G Guest Jun 21, 2005 #1 Can you sum all the numbers in a column that are green only? I do not want to sum numbers in other colors.
Can you sum all the numbers in a column that are green only? I do not want to sum numbers in other colors.
C Chip Pearson Jun 21, 2005 #2 You need a VBA macro to do this. See http://www.cpearson.com/excel/colors.htm , -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
You need a VBA macro to do this. See http://www.cpearson.com/excel/colors.htm , -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com
