|
Conditional formatting - Numbers and words
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% |
Conditional formatting - Numbers and words
Hi,
Icon sets can't test for text entries, only numbers. I don't believe it is possible to do what you want. -- If this helps, please click the Yes button. Cheers, Shane Devenshire "Mark Andrews" wrote: 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% |
| All times are GMT +1. The time now is 03:25 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com