can i access the cell colour programatically? eg if cell is blue

[Guest]

i have a grid of numbers and i want to categorise them and then total by
those categories. the simplest way would be to colour code each cell and do a
conditional sumation based on the colour. can i do this? if not, is there
another easy way to do this?

 

[Guest]

http://www.cpearson.com/excel/SortByColor.htm
http://www.cpearson.com/excel/CFColors.htm

Hi Tony, take a look at Chip Person site.

hth
regards from Brazil
Marcelo

"Tony2Far" escreveu:

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)