Counting Conditionally Formatted Cells

[mkfwaldron]

Is there a way to count the value of a cell only if the cell is red? For example, if there is a column of cells that is all different colors, is there a way to only count the values in the red cells? Each of the different cells were conditionally formatted.

mkfwaldron

 

[VoG]

Hello and welcome to MrExcel.

What is the conditional formatting condition or formula that turns the cells red?

 

[mkfwaldron]

Using the Excel 2007 conditional formating tool: if the value is greater than 1 the cells in that row turn red. However in the next row, if the value is greater than 1 those cells turn blue. There are four different possible labels for the rows and therefore four different color possibilities. This is repeated over 100 or so rows. I want to highlight a column and be able to only count the red values, blue values, etc. of that column.