need formula to add cell sums by color of cell
 

I am working in a imported file that I can't change the format
but I need to pull out the values of different cells so if I change the
color
of the cell, I want to total the value of lets say blue. Is that
possable

Thanks
Bruce


--
Brucet
------------------------------------------------------------------------
Brucet's Profile: http://www.excelforum.com/member.php...o&userid=29983
View this thread: http://www.excelforum.com/showthread...hreadid=496787

need formula to add cell sums by color of cell
 

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

--
Kind regards,

Niek Otten

"Brucet" wrote in
message ...

I am working in a imported file that I can't change the format
but I need to pull out the values of different cells so if I change the
color
of the cell, I want to total the value of lets say blue. Is that
possable

Thanks
Bruce


--
Brucet
------------------------------------------------------------------------
Brucet's Profile:
http://www.excelforum.com/member.php...o&userid=29983
View this thread: http://www.excelforum.com/showthread...hreadid=496787

need formula to add cell sums by color of cell
 

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


Cheers,

Steve


--
SteveG
------------------------------------------------------------------------
SteveG's Profile: http://www.excelforum.com/member.php...fo&userid=7571
View this thread: http://www.excelforum.com/showthread...hreadid=496787