As in the screenshot below, I am trying to make cells in Excel 2007 (Windows) display an arrow depending on the difference which results from the calculation.
Using Conditional Formatting, select a new rule for the cell and choose format style "Icon Sets". Then you should see something that lets you pick arrows, stoplights, etc.