| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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% |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional formatting by key words | Excel Worksheet Functions | |||
| conditional formatting for specific words in cell | Excel Discussion (Misc queries) | |||
| conditional formatting -- testing for multiple words | Excel Discussion (Misc queries) | |||
| conditional formatting on words | Excel Discussion (Misc queries) | |||
| conditional formatting for cells containing words | Excel Discussion (Misc queries) | |||
Threaded Mode
