View Single Post
  #1   Report Post  
John Knoke
 
Posts: n/a
Default formatting colors

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