How do I do a sum using cell colours and data in it.

[ghrek]

I have a workbook and in row 2 between columns D and AE there are some cells that are blank, some that are coloured green and some will be red with the word NO.

What im trying to do is in column AG is input a number for any cells that change colour. If any of the cells that are coloured green in that row change to red and the word NO is put in it I need the number in column AG for that row increased by one and obviously if turned back to green I need it reduced.

How do I do that?

Thanks

 

[ghrek]

Brill Many Thanks again

 

[Fluff]

Glad to help & thanks for the feedback.