Conditional Formatting with Icon sets

C

CC

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?
 
C

CC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting with dates 7
Conditional Formatting using Traffic Lights 6
Conditional formatting with two columns 0
Comparing two columns with conditional formatting 4
Conditional Formatting in Excel 2003 2
CREATING NEW OR ADDING ICON SETS FOR CONDITIONAL FORMATTING 0
Conditional formatting dates 3
Conditional Formatting and arrow icon sets 0

Top