What's the best way to count conditional formats?
 

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?

What's the best way to count conditional formats?
 

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)

"KeefatCWS" wrote in message
...
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?

What's the best way to count conditional formats?
 

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
--
Allllen


"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?

What's the best way to count conditional formats?
 

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?