negative amounts in forms

[Siobhan]

I have created a form from a table of Ebay auctions. I have the following
fields:

Winning bid amount (if any)
Ebay listing fee
Ebay final value fee
PayPal payments fee
Actual item cost
Auction Profit / Loss
Item Profit / Loss

all fields are set to currency

I want the form to automatically calculate the Auction Profit / Loss field
and the Item Profit / Loss field and to show negative amounts in Red.

I would like the second, third and fourth fields to automatically be in
negative amounts since they are fees.

I would like the Item Profit / Loss to display a negative amount if
appropriate. I have the form set up to show some of this now, but not all
calculations are working properly.

What can I do to get this to calculate the way I want?

Thanks,
Siobhan
PS: I am using Office XP

 

[Damon Heron]

Select the field, then go to Format -Conditional Formatting, and set your
conditions and make the font red.

Damon