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

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?

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

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:

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?

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

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)

"Tony2Far" wrote in message
...
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?