Posted to microsoft.public.excel.misc
|
|
if, then, else with Excel 2007 icon sets
You need to use Conditional Formatting with Icon Sets...
See http://blogs.msdn.com/excel/archive/...09/594200.aspx for details.
"bikierguy" wrote:
I am trying to have an independent cell show one of three icons: up arrow,
sideways arrow or a down arrow based upon a formula.
This would be example data:
Week 1 15 Week 2 23 Week 3 23 Week 4 22
The output I expect is (in a independent cell) :
Week 2: up arrow Week 3: sideways arrow Week 4: down arrow
I think I know how to do this with words, but can't seem to get it to work
with icons.
Any thoughts are appreciated.
Thanks,
--
Kevin
Cloverdale, BC
|