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