Excel Progress Bar

[luisitocarrion1900]

How can I use a Cell as a progress Bar that if is 0% to 9% is green if 10% to 50% is yellow and 60% to 100% Red and the cell fills with the color according to the Percentage.

 

[Toadstool]

Hi Luisitocarrion1900,

You can use Conditional Formatting but be careful you cover all ranges (e.g. in your example 9.5% would not be selected).

Book1
	G
1	Percent
2	0%
3	9%
4	10%
5	50%
6	60%
7	100%
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
G2:G7	Expression	=G2>=60%	text	NO
G2:G7	Expression	=AND(G2>=10%,G2<60%)	text	NO
G2:G7	Expression	=AND(G2>=0%,G2<10%)	text	NO

 

[luisitocarrion1900]

this can be used in one cell because the percentage changes on the same cell, also if the cell is 60% will it color 60% of the cell

 

[Toadstool]

No, it colours whole whole cell dependent on its value.

 

[CsJHUN]

Hi Toad, it's in the conditional formating,

Because its cannopt be multicolored i suggest use 3 column, one for red, one for yellow and one for green, based on your needs
lets say "A" is for 0-9% red: Where this red progressbar set to min: 0 max:9
"B" is for 10-50% yellow: yellow progressbar set to min: 10 max 50 (no negative values or bars)
"C" is for 50+ green: green progressbar min 50 max 100 (no negative values or bars)


Yeah i know its 100 days old :D