Have you tried Number Formats?
<Format<Cells<Number tab

or Custom Number Formats? (check Excel help)

or Conditional Formatting?<Format<Conditional Formatting

http://www.contextures.com/xlCondFormat01.html


***********
Regards,
Ron

XL2002, WinXP-Pro


"Blane" wrote:

i'm keeping track of my stock gains and losses...How can I make the formula
determine what color either will be????


Thanks