Associating values to coloured cells

[twright]

Is it possible to associate a value to a coloured cell in excel. ie i
the cell is blue= +1, red=+2 et

 

[Frank Kabel]

Hi
have a look at the following thread
http://tinyurl.com/2u22g.

use Bob's Colorindex function to test a cell for its value and assign
approbiate values to each colorindex