Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
I can't see formatting on my screen for font colors or highlighti. | Excel Discussion (Misc queries) | |||
Formatting dates in the future | Excel Worksheet Functions | |||
Copy conditional formatting across multiple rows? | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |