Excel formulas cannot see the colors in the cells; so if you are manually
coloring them, then you can't do what you want. However, if the cells get
their color from Conditional Formatting, then you should be able to build
your worksheet formulas using the logical formulas from the Conditional
Format.

--
Rick (MVP - Excel)


"thread" wrote in message
...
Hi
i will need to build a sum using the functionalities of excel to
identify if a cell change his color
for example

only green cells should be counted
1(white)
2(white)
3(green)
4(green)
------------
the sum will be 7

it is very easy to do it via vba but i would like to do it via the
functionalities of excel
is it posible?