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:
Originally Posted by FSt1
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? |