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?