Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
if, then, else with Excel 2007 icon sets
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 |
#2
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting with Icon sets | Excel Discussion (Misc queries) | |||
Referencing Icon Sets | Excel Worksheet Functions | |||
How do I apply icon sets to percentage values in Excel worksheet? | Excel Worksheet Functions | |||
Additional Icon Sets | Excel Discussion (Misc queries) | |||
How to create icon sets for excel 2007 conditionnal formating ? | Excel Discussion (Misc queries) |