I need a formula to count the number of cells of the same text color in a column.
S Santiago Aug 4, 2006 #1 I need a formula to count the number of cells of the same text color in a column.
B Bob Greenblatt Aug 4, 2006 #2 I need a formula to count the number of cells of the same text color in a column. Click to expand... You can't do that with a formula. You will need to write a macro to count cells with the same color.
I need a formula to count the number of cells of the same text color in a column. Click to expand... You can't do that with a formula. You will need to write a macro to count cells with the same color.
J JE McGimpsey Aug 6, 2006 #3 Bob Greenblatt said: You can't do that with a formula. You will need to write a macro to count cells with the same color. Click to expand... For instance, see http://cpearson.com/excel/colors.htm
Bob Greenblatt said: You can't do that with a formula. You will need to write a macro to count cells with the same color. Click to expand... For instance, see http://cpearson.com/excel/colors.htm
