formatting colors

[Guest]

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

 

[Guest]

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

 

[Guest]

James, thank you for your help, I tried the conditional formatting as you
mentioned but it does not work

 

[John O. Knoke]

James,
Sorry my mistake, it works perfect.

James, thank you for your help, I tried the conditional formatting as you
mentioned but it does not work