He knows how to create a macro that will examine the cell color and do a count if a cell is formatted directly as red, but the macro won't work with cells that are conditionally formatted. He wants to count the number of cells that are red in the worksheet. The conditions result in the cells being different colors. Ronald has a worksheet that utilizes conditional formatting.