Could you count the scores that satisfied the CF?
If not...................
See Chip Pearson's site for working with CF colors.
http://www.cpearson.com/excel/CFColors.htm
Gord Dibben MS Excel MVP
On Thu, 31 Aug 2006 09:13:02 -0700, KeefatCWS
wrote:
I'm building a spread sheet for Office Football Pools. I used conditional
formatting so once a score was entered it would format the cell with a
pattern if the person picked the correct winner. Is there a way to count the
conditional formats to tally total wins?