How do I reference a cell that has a colored background?

How do I reference a cell that has a colored background? I would like to sum
only the colored cells in a row. The cells are colored manually to identify
them.

MCLENNB ha scritto:
> How do I reference a cell that has a colored background? I would like to sum
> only the colored cells in a row. The cells are colored manually to identify
> them.

http://www.ozgrid.com/VBA/sum-count-cells-by-color.htm

See http://www.xldynamic.com/source/xld.ColourCounter.html

--
HTH

Bob Phillips

"MCLENNB" <[email protected]> wrote in message
news:[email protected]...
> How do I reference a cell that has a colored background? I would like to
sum
> only the colored cells in a row. The cells are colored manually to
identify
> them.