How to count cells that are highlighted by conditional formatting
 

How do I return a count of how many cells in a range are highlighted (via
conditional formatting) without using VBA in Excel 2007?

How to count cells that are highlighted by conditional formatting
 

What conditions are used to set the CF in those cells? You need to
construct a formula which incorporates those conditions - this might
be a simple SUMIF if the condition is simple (eg cell greater than
10), but may need to be more complex than this. Post back with further
details if you need more help.

Hope this helps.

Pete

On Feb 10, 3:11*pm, jngbutler35
wrote:
How do I return a count of how many cells in a range are highlighted (via
conditional formatting) without using VBA in Excel 2007?