How do I format a cell using symbols within a formula?
G13: =IF(D13F13,CHAR(225),IF(D13<F13,CHAR(226),CHAR(22 4)))
Format font in G13 as Wingdings
Condition 1:
Formula Is =$D$13$F$13
format as Green
Condition 2:
Formula Is =$D$13<$F$13
format as Red
"divewater" wrote:
How do I format a cell so that it will display a symbol such as: green arrow
up, red arrow down, or black horizontal arrow? This would be used to show
the rise, fall, or steadiness of day-to-day stock prices, as follows: 1) if
d13f13, then green arrow up, 2) if d13<f13, then red arrow down, or 3) if
d13=f13, then black horizontal arrow.
|