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?

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?

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?

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?

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