Just a little more thinking outside the box.
If it wasn't vital that you used -2,-1,0,1,2 and changed to all positive
numbers, ie, 1,2,3,4,5.
You could use this formula instead.

=CHOOSE(C38,"loss","loss",0,"win","win")

I obviously need to get a real life !!
Regards
Michael Mitchelson


"Michael" wrote:

Hi
As you only have 3 conditions, try using Conditional Formatting.
Use cell value is equal to WIN, Cell value is equal to LOSS and cell value
is equal to 0
You could also consider changing your formula to:
=IF(OR(C38=1,C38=2),"WIN",IF(OR(C38=-1,C38=-2),"LOSS",0))


HTH
Michael Mitchelson


"News Account" wrote:

Is it possible to define a text value in an IF function to a particular
colour, the function is

=IF(C38=1,"Win",IF(C38=2,"Win",IF(C38=-1,"Loss",IF(C38=-2,"Loss",IF(C38=0,0)
))))

I would prefer the "Loss" to entered automatically in red.

Many thanks