making gains or losses appear red or black in formula

[Blane]

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


Thanks

 

[Ron Coderre]

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