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 using Traffic Lights 6
Conditional Formatting with Icon Sets 0
Setting an Icon Set conditional format for a single cell??? 4
Conditional Formula formatting 2
Conditional Format Objects? 3
Conditional Formatting for 6 inputs 3
Conditional Format Negative to Postiive Numbers w/3 Symbol Icon Se 2
Formatting Conditional Formatting Icon Sets 3

Top