Use cell color as criteria in formula
 

Hi,
I have column with values. some of the cells are with color. i have index of
colors with % (probability) for each color.
I try to use formula that sum the column when the colored cells are multiple
with the % in the index according the color they have (blank cells will sum
regulary).
Thanks.

Use cell color as criteria in formula
 

Look he

http://www.cpearson.com/excel/colors.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"michael goldberger" wrote in message
...
| Hi,
| I have column with values. some of the cells are with color. i have index of
| colors with % (probability) for each color.
| I try to use formula that sum the column when the colored cells are multiple
| with the % in the index according the color they have (blank cells will sum
| regulary).
| Thanks.

Use cell color as criteria in formula
 

Can you post an example?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"michael goldberger" wrote in
message ...
Hi,
I have column with values. some of the cells are with color. i have index
of
colors with % (probability) for each color.
I try to use formula that sum the column when the colored cells are
multiple
with the % in the index according the color they have (blank cells will
sum
regulary).
Thanks.