Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Icon sets
I thought this would be easy, but I cannot figure out how to use conditional
formatting with iconsets the way I want. If I am comparing results from one month to the next I want to show a green light or arrow if the current month's sales were higher than last month, a yellow light if it was the same and a red light if it declined. Month 1 Month 2 50 60 - green 55 55- yellow 60 50 - red This seems pretty basic, am I missing something simple? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Icon sets
hi
what do you mean by "light" or "arrow"? regards FSt1 "CC" wrote: I thought this would be easy, but I cannot figure out how to use conditional formatting with iconsets the way I want. If I am comparing results from one month to the next I want to show a green light or arrow if the current month's sales were higher than last month, a yellow light if it was the same and a red light if it declined. Month 1 Month 2 50 60 - green 55 55- yellow 60 50 - red This seems pretty basic, am I missing something simple? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Icon sets
Hi -
I want to display one of the new icon sets as a result of the conditional formatting so you can quickly see if the numbers went up or down from the previous month CC "FSt1" wrote: hi what do you mean by "light" or "arrow"? regards FSt1 "CC" wrote: I thought this would be easy, but I cannot figure out how to use conditional formatting with iconsets the way I want. If I am comparing results from one month to the next I want to show a green light or arrow if the current month's sales were higher than last month, a yellow light if it was the same and a red light if it declined. Month 1 Month 2 50 60 - green 55 55- yellow 60 50 - red This seems pretty basic, am I missing something simple? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Formatting with Icon sets
hi
sorry it took me so long to get back, i got hung up. see this web site.... http://msdn.microsoft.com/en-us/libr...ffice.11).aspx regards FSt1 "CC" wrote: Hi - I want to display one of the new icon sets as a result of the conditional formatting so you can quickly see if the numbers went up or down from the previous month CC "FSt1" wrote: hi what do you mean by "light" or "arrow"? regards FSt1 "CC" wrote: I thought this would be easy, but I cannot figure out how to use conditional formatting with iconsets the way I want. If I am comparing results from one month to the next I want to show a green light or arrow if the current month's sales were higher than last month, a yellow light if it was the same and a red light if it declined. Month 1 Month 2 50 60 - green 55 55- yellow 60 50 - red This seems pretty basic, am I missing something simple? |
#5
|
|||
|
|||
This doens't answer his question? I have the same question. I want an arrow to show whether the number has gone up or down relative to the previous figure.
So: 10 ^40 v3 ^200 v9 9 The link below, doesn't answer the question. Can someone please help? Thanks Quote:
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I apply icon sets to percentage values in Excel worksheet? | Excel Worksheet Functions | |||
Conditional Formatting with the icon set | Excel Discussion (Misc queries) | |||
conditional formatting for multiple sets of conditions | Excel Discussion (Misc queries) | |||
Basis of Icon Set (conditional formatting) Excel 2007 | Excel Discussion (Misc queries) | |||
Additional Icon Sets | Excel Discussion (Misc queries) |