Solved

Conditional Formatting

Posted on 2013-11-25
9
145 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
  • 3
  • 3
  • 2
9 Comments
 
LVL 1

Expert Comment

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

Expert Comment

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

Author Comment

by:Seamus2626
Comment Utility
Thanks techartisan, but i actually need the symbols of the traffic lights if thats possible?
0
 
LVL 1

Expert Comment

by:TechArtisan
Comment Utility
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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 
LVL 48

Expert Comment

by:Rgonzo1971
Comment Utility
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
Comment Utility
Perfect, i understand now
0
 
LVL 48

Accepted Solution

by:
Rgonzo1971 earned 500 total points
Comment Utility
Hi,

Have you seen my solution?

Regards
IA-MI-EE-Vers2.xlsx
0
 

Author Comment

by:Seamus2626
Comment Utility
Im getting the q reopened rgonzo
0

Featured Post

Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

Join & Write a Comment

Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
This tutorial explains how to create a series of drop-down lists that are dependent upon prior selections to guide (“force”) the user to make the correct selection and reduce data errors within Microsoft Excel. Excel 2010 was used for this tutorial;…
Viewers will learn the basics of slicers and timelines for both PivotTables and standard Excel tables in Excel 2013.
The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

744 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now