Conditional format

[LGMan]

Hi,
Is there anyway that I can use conditional formats to show a specific text character dependant on whether the number in the cell to it's left is 0, greater than 0, or less than 0.
I aim to use the Wingdings 3 font with the letters P, Q and TU to show the arrows
In my example...
Col.A, is 'Last Week'
Col.B is 'This Week'
Col.C is 'Movement'
Col.D is where I want to show the arrows

[output]
-A- -B- -C- -D-
5 4 -1 (down arrow)
3 5 2 (up arrow)
2 2 0 (Sideways arrow)
[/output]

Thanks for any help

 

[SkipVought]

Hi,

That's not a FORMAT thing, its a FORMULA thing.

Make a formula like...
[tt]
=if(a2<b2,"P",if(a2>b2,"Q","T"))
[/tt]


Skip,
^{Don't let the Diatribe...
talk you to death!}
_{Just traded in my old subtlety...
for a NUANCE!}

 

[mintjulep]

No need for conditional formatting (which doesn't do what you want anyway).

A simple if formula will do the job.

=IF(C1<0,"q",IF(C1>0,"p","tu"))

Copy down and change the column font to wingdings3.

 

[LGMan]

Thanks Skip for the speedy reply

 

[DaveInIowa]

If you're using Excel 2007 you can apply a Conditional Formatting -> Icon Set to Column C and have the arrow icons right in the same cell as the value.