I have a worksheet and a need to sum cells with a certain font-color.

I have a number of rows with tasks listed. In the coloums i have 12
months and i the cells are workhours per task per month placed
registrered.

A task can be given a status like this :1) not stated = red, 2 started
= orange,
done = green.

I need to have 3 sums to the right of each tast. A sum for the "Not
started" hours (=red), a sum for the "Stated" hours (=orange) and a
sum for the "Done" hours" (=green).

I now i have to use macros and the need to recalculate with F9 is OK.

But figuring out the macro and how to get the result put in the "sum-
cells" is the ?

Anyone?