Hi JE

you're absolutely correct - sorry, John ... Chip has notes on working with
CF, but i'ld recommend the method suggested by JE McGimpsey about using the
formula/criteria that you're using to generate the conditional formatting in
the first place.

Cheers
JulieD

"JE McGimpsey" wrote in message
...
Hmm...

That doesn't work when the color is applied using CF...

In article ,
"JulieD" wrote:

Chip Pearson has some code on his website to do this
http://www.cpearson.com/excel/colors.htm

it's about the third article down, "Counting cells with a specific color"