Count If / color criteria

[G.]

Is there a way to use count if (or some other formula) to count the only the
number of "x"s in a collumn that are red (or count the number of cells in a
collum that are highlighted with a different color). TIA for any help. G

 

[Debra Dalgleish]

There's nothing built into Excel that lets you count by colour. Chip
Pearson has some User Defined Functions that you can use:

http://www.cpearson.com/excel/colors.htm