I have a spreadsheet with several rows. The background of the rows can
either be coloured Red, Orange, Green or white.

What I want to do is have a running total for each colour, so that if a row
is set with a green background it will increment the Green total by one. If
an Orange row is changed to Red, the Orange count will drop by one, and the
Red count will go up by one.

Is this possible, and if so, how?

Rgds

Duncan