icon sets

Hi, I have a single column of cummulative stock market returns going up and down on a daily basis. I'd like to have an up arrow show in the cell in question if the previous value in the column was lower and vice versa. By cummulative stock returns, I mean if A1 shows the returns for January...

Hello Dear, I have used Icon Sets of Conditional Formatting for this range based on the criteria shown in the attached picture, but why 6 is amber while it's 60% and the criterion states >= 60% which should be green, doesn't the 6 equal 60%? (Max=10 and Min=1, 6/10=60%) similarly, while...

I have a field that is simply calculating the difference between two other fields. Although the results are negative numbers, positive numbers or 0, the person who requested the report wants to see the absolute value. So I used ABS(c2-e2). They also wanted icon sets (the arrows), so they can...

Dear Excel Folks, I am trying to create a worksheet to show trends in students performance in a fitness test. I want to display icons to show whether their present attempt was better, in line with or worse than their previous effort. So for example if score 2 was better than score one it would...

Greetings - I'm using Excel 2011 for Mac. My watered down example consists of tracking "start" and "end" over a period of 7 days. So not including headers/labels there are 2 rows (B2:I3) and 7 columns. The data are all integers. I want to compare the value of B2 to B3 and display a "check"...

Good evening, i have problem with Conditional formatting icon sets. I use basic dots (green, yellow and red). If percentage is more or equal than 80 its green, if percentage is less than 80 and more or equal than 40 its yellow, and if percentage if less than 40 its red. But when I apply the...

Hi I have used a conditional format for "icon sets" in Excel 2013 the traffic light option. Green >= 100, Orange >=80 Red <80 All worked fine on my first sheet however, when I tried to repeat it in 2 more sheets (in the same workbook) the green and orange are appearing red. Has that...

I need a formula that would allow me to use all three arrows (red, yellow, and green) depending on if the cells being compared are <, =, or >. Less would be red, = would be yellow, and greater would be green. Currently I am using an if formula if(A1>A2,3,1), and applying the conditional...

I do a daily stocktake at work. Every day I enter a row of values based on my stocktake. I've noticed Icon sets and would like to change the icon in relation to the previous day's number. IE. I'd like an up arrow if amount is higher, down arrow if lower and horizontal arrow if the same. Is...

I am a teacher making a spreadsheet so that I can input various bits of info about my classes throughout the week and then with a quick glance see for example what classes I'm teaching Tuesday or what topic my year 9s are doing Friday etc. I have several columns with conditional formatting for...

I want to set up a simple conditional formatting with a 3 piece icon set, with the following: If cell b2 is greater than a2 a green arrow if cell b2 is equal to a2 a yellow arrow if cell b2 is less than a2 a red arrow How do yo set up the conditions? Thanks in advance.

Is it possible to change the traffic light colours on Icon Style: 4 Traffic Lights? I would like to change the black light to white, if possible. Thanks in advance

I’ll give an example to hopefully make this faster. In Column "Tear Height" or column AJ, row 161, I have a value of 200. Going down the table (each row is a new bond for what I’m doing, so a parameter is going to be changed. It will not always be the same parameter changing), the value of 200...

Hello, I try to use conditional formation to apply traffic light icon, based on cell value. value => 70 and value<=100 green light value => 40 and value<70 yellow light value => 0 and value<40 red light my current code is like: Sub col() ThisWorkbook.Sheets("score").Activate For l = 2 To...

Hi... I have worksheets that i use the 3-Trafiic Light Iconsets with Conditional Formatting. My question is, is it possible to use these Iconsets (red, yellow, green traffic lights) on my userform? For instance, if I create say a label on my userform could I place one of the traffic lights in...

This question has probably been answered a million times, but.... I am putting a customer sentiment dashboard together that is based on a 5-star rating. 1 not so good and 5 = We Love It. We would like to use a somewhat unique icon set that has 5 stars of which could be colored in partially or...

Hi - I'm a newbie here so apologies if my answer is to be found somwhere already. Excel 2010 conditional formatting - I want use conditional formatting using icon sets, however, I need to use my own graphics instead of the arrows, flags and other shapes available in the existing icon sets. Is...

Hi, I wonder if anyone can help me with this. I do not know VBA code. I am fairly ok with using excel. I have a large spreadsheet and I have various sets of records in the spreadsheet coming in from different sources. They are all RAG rated. I now want to hide all the records that are RAG rated...

I would like to know if there is a way to have a conditional formatting that is able to display bars in different colors by using different criteria. The conditions are the following: Limits for positive results = Min: 0 , Max: 4 Limits for Negative results = Min: -Target A , Max: 0 If cell...

Does anyone know, when using icon sets for conditional formatting, if there is a way to have a neutral value simply be blank? When scattered over a field of data, the neutral indicator seems distracting to me. I would like the ups and the downs to standout and the neutrals not even display...