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

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

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

"James W." wrote:

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

James,
Sorry my mistake, it works perfect.

"John Knoke" wrote in message
...
James, thank you for your help, I tried the conditional formatting as you
mentioned but it does not work

"James W." wrote:

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