See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

This should point you in the right direction, advice taken from an earlier
post.

"Andri" wrote:

Dear All,

I need to check certain cell, if the format colour is Red, i want to put
figure 1, Black = 2, Blue =3.

Please help by using formula?

Thank you for your kind attention.

Andri