Use Conditional Formatting...
select the cell containing your formula goto Format, Conditional
Formatting... then cell value is equal to =CHAR(196), format it red.


"John Knoke" wrote:

I am working with wingdings 2 characters in my €œif€� formula and they work
fine. Here is an example:
=IF(H10=0,CHAR(227),IF(H10=-0.01,CHAR(162),IF(H10<-0.01,CHAR(196),"")))

My question is how do I format the cell if:
Char(227) format the character green
Char(162) format the character yellow
Char(196) format the character red

Thanks for any help