Formatting with traffic lights

Hi

I would like to use a formatção with icons (traffic lights), in column "G"

It turns out that I need to be obeyed in accordance with the criteria below.

Green (30...) 30%
Yellow (20-29) 20%
Red (0-19) 0%

See my attachment

Try changing the type to Number and then make the Value

Green .3
Yellow .2

a little laggy with the internet today. i have the same answer as jeffrey, but something additional as i saw your range applied to seems to be parts by parts. i assume you use the CTRL key to select.

1. select from G2:G29
2. go to Home -> Conditional Formatting -> New Rule -> Format all cells based on their values -> Format Style: Icon Sets
3. Change both Type: Number
4. green when value is >= 0.3
5. yellow when value is >=0.2
6. OK

Hi
it's a good idea, but i can't use this way.

I need percent format (value cell).

Is there other option?

thank you!!

.3 and .2 is a percentage, it's just in a decimal form.

Did you try the suggestions? How is it not producing the correct result?

Hi.
It did not work the way I need.

how do I use icon within a formula?

excel have this option?

Originally Posted by marreco

It did not work the way I need.

How did it not work the way you intended? Did you get a wrong result?

The two answers you were given work by turning G2 "yellow".

I finally got the icons to work properly:

Select G2:G29.

Change the format of the selection to NUMBER.

Click on Conditional Formatting, Choose Icon Sets and choose the Stop Lights.

Click on Conditional Formatting, Click on Manage Rules.

Select the rule that you just made and click on Edit Rule

For the Green Light select >= and enter .3 and type NUMBER

For the Yellow Light select >= and enter .2 and type NUMBER

Click OK, OK

On the Home tab (your column of values is still selected) in the Number Group, click on the formatting field and choose PERCENTAGE. All the numbers in the selection will now be % and G2 should now be YELLOW.