Conditional format a row according to the highest cell value

[Legacy 143009]

Hi,

I state each time proudly that I am quite bad at conditional formatting
I have a set of survey results and I populated answer percentages per question.

C	D	E	F
Questions	YES	MAYBE	NO
1. Question1	%66	%33	%0

I want to highlight each row from column D to F, like if closer to "100% YES" more green and closer to "100% NO" more red.
Does it make any sense?
My data ranges from D2:F19. Thanks a lot!

I don't know what to expect either. Maybe a weighting system can be created. Maybe it can be the weighted avarage of three answers. I am expecting something like this:

 

[Sufiyan97]

Try

Book3
	A	B	C	D	E	F	G	H
1				YES	MAYBE	NO
2				0	0.333	0.667
3				0	0	1
4				0.333	0.333	0.333
5				0.667	0.333	0
6				1	0	0
7
8
9
10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:F6	Expression	=AND($D2>0.667,$E2>=0,$F2>=0)	text	NO
D2:F6	Expression	=AND($D2>0.333,$E2>0,$F2>=0)	text	NO
D2:F6	Expression	=AND($D2>0,$E2>0,$F2>0,$D2=$E2,$E2=$F2)	text	NO
D2:F6	Expression	=AND($D2>=0,$F2>0.667)	text	NO
D2:F6	Expression	=AND($D2>=0,$F2>=0.667)	text	NO

 

[Legacy 143009]

Try

Book3
	A	B	C	D	E	F	G	H
1				YES	MAYBE	NO
2				0	0.333	0.667
3				0	0	1
4				0.333	0.333	0.333
5				0.667	0.333	0
6				1	0	0
7
8
9
10
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:F6	Expression	=AND($D2>0.667,$E2>=0,$F2>=0)	text	NO
D2:F6	Expression	=AND($D2>0.333,$E2>0,$F2>=0)	text	NO
D2:F6	Expression	=AND($D2>0,$E2>0,$F2>0,$D2=$E2,$E2=$F2)	text	NO
D2:F6	Expression	=AND($D2>=0,$F2>0.667)	text	NO
D2:F6	Expression	=AND($D2>=0,$F2>=0.667)	text	NO

Thanks for your time and effort.
I came up with a formula which is:
=1-F2-(E2/2)
So, speaking of the first row, what I want is to make the row greener if this value approaches to 1 and redder if value approaches to 0.
Which steps should I follow?

 

[Sufiyan97]

Go to Conditional formatting > New Rule

Put the formula here

Book3
	C	D	E	F	G
1		YES	MAYBE	NO
2		0	0.333	0.667
3		0	0	1
4		0.333	0.333	0.333
5		0.667	0.333	0
6		1	0	0
7
8
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
D2:F6	Expression	=ROUND(1-$F2-($E2/2),0)=1	text	NO
D2:F6	Expression	=ROUND(1-$F2-($E2/2),0)=0	text	NO

 

[Legacy 143009]

What I mean by greener and redder is, I mean gradian
0 red, 0.5 yellow, 1 green. It should evaluate according to the result of this formula =1-F2-(E2/2)

 

[Sufiyan97]

Sorry, I am not able to do it

Hope someone else can help you in this.

 

[Legacy 143009]

Thanks for your time and support
I think it is not achievable according to this post:

Excel conditional format color scale formula

I have a column of data in Excel (column Y) that I'd like to apply a 3 color scale to based on how it compares to a second column (column B). What I would like to have is a green color if it is gre...

stackoverflow.com