Count of Color Formatted Cells (2003)

Topic

New Reply

greetings,

Not sure if this is possible or not.

I have a column of data, where I am using conditional formatting to color cells. I am wondering if it is possible to get a count of the NON color filled cells?

Regards.
Brad

Reply | Quote

Replies

Depends on how the conditional formatting is set up. You may be able to use Conditional Formatting Colors, but it might be better to use a formula based on the same conditions that you use for conditional formatting.

Reply | Quote

I shall dig into this. In looking at the stuff from Mr. Pearson, I am thinking a formula might be better.

Thanks,
BRad

Reply | Quote