Take a look at http://www.xldynamic.com/source/xld.ColourCounter.html for a
full colour counting solution. It could be adapted for format as well, but
there is no dynamic recalculation with colours or formats.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Naguib" wrote in message
...
Hi

I have a spreadsheet which has a number of formatted fields. Basically,
it's
a list of numbers where each number is coloured a specific colour to
correspond to the matter.

I'm looking for a way to:
a) count the number of fields that have that specific colour and
formatting
so that I can track how many are left of that particular matter
b) find a way of changing the colour of a field once it has been dealt
with

At the moment, I'm having to manually count the fields that have a
specific
colour and also have to manually change the field colour once I have dealt
with it.

Any help on this would be great!

Thanks