After using conditional formatting to color certain cells red, can I use a
function such as 'countif' to count the number of cells that have red
formatting? I know I can write my own function to do this, but would prefer
to use a built in function if one is available.

No built-in function.

Can you count using the same criterion that CF uses to color the cells?

Before you write your own function, visit Chip Pearson's site for code.

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


Gord Dibben MS Excel MVP

On Tue, 8 Aug 2006 10:51:01 -0700, KristinG
wrote:

After using conditional formatting to color certain cells red, can I use a
function such as 'countif' to count the number of cells that have red
formatting? I know I can write my own function to do this, but would prefer
to use a built in function if one is available.