Conditional formatting - Numbers and words

[Mark Andrews]

Hi.. I would like to use and Icon set with multiple formulas. I have both
number data (+20%, -20%) and Letters (Up, Down). If I am using the 3 arrows
icons how do I set up the format so:

0 or “Up†gets a Green arrow

=0 or “Flat†gets a Yellow arrow
<0 or “Down†gets a Red Arrow

Thanks for your help!

Company LS Acad Gov Food Safety Envir Chemical
Agilent -11% 10% 10% 30% NA Down
Dionex Up NA NA Up Up Down
Life Down Up Up Up Up Up
Thermo Down Flat/Down Up Up Flat/Down Down
Waters -7% 15% 25% 28% -23% -19%

 

[Shane Devenshire]

Hi,

Icon sets can't test for text entries, only numbers. I don't believe it is
possible to do what you want.