What's the best way to count conditional formats?

[Guest]

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?

 

[Bob Phillips]

best way is to use the same condition as a formula and count those.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Yes, it is possible but it is pretty complex stuff.
http://www.cpearson.com/excel/CFColors.htm
The mind boggles.

Why don't you find a way of counting the underlying condition instead?
For example, add anther column saying:
=IF(prediction=actual,"yes","no")
then count all the yeses

HTH

 

[Gord Dibben]

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