|I don't have Excel 2007 on the machine I am currently sitting at, but it is my understanding that Excel 2007/2010 has a function for counting colors.|
Earlier versions did not, but there are User Defined Functions (UDF) available via a Google search that will count colors in earlier versions.
All that said, I don't recall if a cell filled by Conditional Formatting are recognized as "filled" by either the UDFs or the 2007 functions.
I can play around this weekend at home where I have 2010 assuming you don't discover something on your own in the meantime. If you do find an answer, please post it here both to get the solution into the archives and (more importantly) save me the work. ;-)
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.