Conditional formatting based on criteria

[Jayfaku]

In worksheet I have drop down YES/NO in column P

If P is "Yes", I want Q:U to be all filled with say colour red
If if P is "NO" then no conditional formatting applies
But also if Q has a "Yes", the everything P:U turns Yellow
And if Q is a "NO", then P:U is Green

Could you please assist?

Thank you

 

[Peter_SSs]

If if P is "NO" then no conditional formatting applies
But also if Q has a "Yes", the everything P:U turns Yellow

That is not clear to me. What if P is NO and Q is Yes?
Does NO win and there is no formatting applied, or does Yes win and yellow is applied to P:U?

 

[Jayfaku]

There will never be a NO in P and Yes in Q
If there is a NO in P the rest of the column don't apply
Effect comes to play when P is Yes

 

[Peter_SSs]

OK, try this. For my layout below ..

Select P2:U6 and apply the CF formula for green.

With P2:U6 still selected apply the CF formula for yellow

Now select Q2:U6 and apply the conditional formatting formula shown below for red

Excel Workbook
	P	Q	R	S	T	U
1
2	YES
3	NO
4
5		YES
6		NO
CF

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
P2	1. / Formula is =$Q2="NO"	Abc
P2	2. / Formula is =$Q2="YES"	Abc
Q2	1. / Formula is =$Q2="NO"	Abc
Q2	2. / Formula is =$Q2="YES"	Abc
Q2	3. / Formula is =$P2="YES"	Abc