You say you want a toggle, but how is that to be implemented?
As for the count, you'll need to use a formula such as SUMPRODUCT or SUMIFS that uses the same logic as your conditional formatting to tally the items.
__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]
|