BAR COLOR

[Pietro Di Micio]

I am facing some issue to create a bar with color change; I mean green >= 80% and <=100%, yellow >=50% and <80% and red >=0% and <50%

Could you help me on that?

pdm_cockpit.xlsx
	S	T	U	V	W	X
35
36
37	WHY CHANGE	WHY NOW	WHY X	DECISION MAKER	PROPOSAL	COLOR CODE2
38	y	y	y	y	y	|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||100%
39
40
41
COCKPIT - CQ

Cell Formulas
Range	Formula
X38	X38	=REPT("|",(COUNTIF(Table1[@[WHY CHANGE]:[PROPOSAL]],"y")/5)*75)&(COUNTIF(Table1[@[WHY CHANGE]:[PROPOSAL]],"y")/5)*100&"%"
X41	X41	=REPT("|",(SUMIF(Table1[@[WHY CHANGE]:[PROPOSAL]],"y",S39:W39))*91)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
X38	Cell Value	between 50*75 and 79*75	text	NO
X38	Cell Value	between 80*75 and 100*75	text	NO
S38:W38	Cell Value	="-"	text	NO
S38:W38	Cell Value	="n"	text	NO
S38:W38	Cell Value	="y"	text	NO

 

[Scott Huish]

The values in X38, do not contain numerical values, it contains a whole bunch of pipe symbols then an amount, so you will need to use a formula in your conditional formatting to determine the values and what you're comparing too, or how many bars your generating, or something like that.
I don't understand your formulas, nor your values in CF: 50*75=3,750 and 79*75=5,925. Where did that come from?

 

[Pietro Di Micio]

I've gotten; tks!