Traffic Light Conditional Formatting

**hzaz** · 04-30-2013, 06:07 PM

Hey;

I am trying to use the traffic light in Conditional formatting, i want EACH cell to display the traffic light as follow:
Green >= 80%
Yellow >= 50% and <80%
red < 50%

easy it sounds, what i noticed is if i have a list of cells, traffic light are not updated based on the single value of the current cell, but are somehow related to the values in the other cells

For ex, list the below values in an excel sheet, and use the traffic formatting: (if you add other values to the list also with the same formatting the colors will change

20% ----->> should be red, displays green
50% ------->> should be orange displays red
100%

how can i make the traffic light reflect the status of the cell , and only the cell not to be related to the other cells.

**jsch08** · 04-30-2013, 11:26 PM

This is similar to what I posted. I am wondering it myself.

**hzaz** · 05-01-2013, 01:35 PM

so , no solution for that?

**nemo74** · 05-01-2013, 01:53 PM

When I listed those numbers they are as follows:

20 ---- red
50 ---- Yells
100 --- Green

I don't know what I'm missing.

Edit:
So what I am missing is common sense. I read the whole OP wrong. I would use CF as a formula to change the colors.

**FDibbins** · 05-01-2013, 02:10 PM

My understanding of thatstyle of CF is that it compares each value in a range, to the total of that range, and colors it accordingly. So, even if you just CF a single cell, containing 20%, and say that that all values over 50% should be red, the 20% will turn red because 20% is actually 100% of that range