Conditional graphics based on values in field

[rondo]

In Excel 2003, I would like to make a formula that will adjust four
KPI-visualizations based on a calculated value in other fields.

The graphics are arrows in red, yellow and green, the green pointing
upwards, yellow to the middle and the red one pointing downwards. I want
them to be in a cell, or at least, to be at the same place whether they are
green, yellow or red.

I'm quite sure this should be possible in some way, but how?

 

[Debra Dalgleish]

You could format a cell with Wingdings font, and enter a formula similar
to the following:

=IF(C2<B2,CHAR(234),IF(C2>B2,CHAR(233),CHAR(232)))

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

Select the cell (D2 in this example) and format with yellow font.
Choose Format>Conditional Formatting
From the first dropdown, choose Formula Is
In the formula box, type: =D2=CHAR(234)
Click Format, and choose Red as the font colour
Click OK, click Add
From the first dropdown, choose Formula Is
In the formula box, type: =D2=CHAR(233)
Click Format, and choose Green as the font colour
Click OK, click OK