Chip has code for colour work at www.cpearson.com
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"TimH" wrote in message
...
I have a column of numbers. The numbers themselves have no signs. If they
are green, they are positive. If they are red, they are negative. Can i
creat a formula that will convert them into numbers with the appropriate
sign?