can i use format (font color) in an if argument?

[TimH]

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?

 

[Bernard Liengme]

Chip has code for colour work at www.cpearson.com
best wishes