You could format a cell (D2 in this example) with Wingdings font, and
enter a formula similar to the following:

=IF(C2<C1,CHAR(234),IF(C2C1,CHAR(233),CHAR(232)))

In Wingdings font, 234 is a down arrow, 233 is an up arrow, and 232 is a
sideways arrow.

Select the cell and format with green font.
Choose FormatConditional Formatting
From the first dropdown, choose Cell Value Is
In the next dropdown, choose 'equal to'
In the formula box, hold the Alt key and on the
number keypad, type: 0234
Click Format, and choose Red as the font colour
Click OK, click Add
From the first dropdown, choose Cell Value Is
In the next dropdown, choose 'equal to'
In the formula box, hold the Alt key and on the
number keypad, type: 0232
Click Format, and choose Yellow as the font colour
Click OK, click OK


Copy the formula down to the last row of data




Lynda wrote:
Having a shocker today guys, got questions all over the place.
(Excel 2003) In my spreadsheet I have to use traffic light colours to show
if certain data is either good, okay or needs attention. This would generally
be fine as I could use conditional formatting but my supervisor wants to
also, along with the colours, put up, down and sideways arrows in the in the
coloured cells. Can anyone advise me on how I can do this?



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html