View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Marcelo Marcelo is offline
external usenet poster
 
Posts: 1,047
Default 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?