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" <MCLENNB@discussions.microsoft.com> wrote in message
news:869565D0-6341-4F02-87ED-5A1301837773@microsoft.com...
> 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.