the subject is discussed here

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

Mike

"oldLearner57" wrote:

hi community

is there a possibilities that i can do a sumation on shaded cells....

example:

i had filled up a range of cells with numeric data and i shaded some cell with
color....


A B C D

1 10 20 30 40

2 30 34 45 45

3 45 45 50 45

example above, say i shaded A3 with tan color & B2 with tan color & C1 with
tan color
than
I wish to use the sum by the shaded color ...
is this possible?

thanks community for the assistance :)

thanks all

--
oldLearner57