Solved

Conditional Formatting

Posted on 2013-11-25
9
154 Views
Last Modified: 2013-11-29
Hi,

Attached is a sheet where i want to use 2010's new icon sets (conditional formatting)

Can someone set up the formatting using the traffic lights (rimmed)

So if there is a decrease its a green light and an increase its a red light, and if it has no change, its amber

Many thanks
IA-MI-EE.xlsx
0
Comment
Question by:Seamus2626
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 3
  • 2
9 Comments
 
LVL 1

Expert Comment

by:TechArtisan
ID: 39674738
Such as the attached?
IA-MI-EE.xlsx
0
 
LVL 1

Expert Comment

by:TechArtisan
ID: 39674747
Sorry this one is the correct file.
IA-MI-EE.xlsx
0
 

Author Comment

by:Seamus2626
ID: 39674758
Thanks techartisan, but i actually need the symbols of the traffic lights if thats possible?
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 1

Expert Comment

by:TechArtisan
ID: 39674778
Unfortunately the traffic light system is for comparing numbers, and I do not believe there is any way to modify this for comparing the text in the field.
0
 
LVL 51

Expert Comment

by:Rgonzo1971
ID: 39674789
Hi,

is this what you are looking for?

You can use a custom format to show decrease Increase and Same as a result of the calculation D6 -C6 "Increase" for a positive number, Decrease for a negative number and "Same"  for zero you can  afterwards insert the traffic lights

Regards
IA-MI-EE-Vers1.xlsx
0
 

Author Comment

by:Seamus2626
ID: 39674803
Perfect, i understand now
0
 
LVL 51

Accepted Solution

by:
Rgonzo1971 earned 500 total points
ID: 39674818
Hi,

Have you seen my solution?

Regards
IA-MI-EE-Vers2.xlsx
0
 

Author Comment

by:Seamus2626
ID: 39674827
Im getting the q reopened rgonzo
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question