Conditional formatting with multiple statements

[rmak85]

Hello I need some help with conditional formating.

Cell C has drop down for "Anode Mother Roll" and"Cathode Mother Roll"
Cell P is result 1
Cell Q is result 2

In the results i need to change the cell to either green orred depending on the value inputted.

If Anode Mother Roll and result is <=1350 = green,>1350 = red
if Cathode Mother Roll and result is <=520 = green,>520 = red

Code for Red

=OR((AND($C7="Anode MotherRoll",$Q7>1350)),(AND($C7="Cathode MotherRoll",$P7>520)),(AND($C7="Cathode Mother Roll",$Q7>520)))

Code for Green

=OR((AND($C7="Anode MotherRoll",$Q7<=1350)),OR(AND($C7="Cathode MotherRoll",$P7<=520)),OR(AND($C7="Cathode MotherRoll",$Q7<=520)))[/COLOR][/SIZE][/FONT]

I cant get the results to change independantly depending onthe drop list item?

 

[Special-K99]

You've spelt "Mother Roll" without a space in the Condtional formatting

 

[rmak85]

Apologies, it was just a paste error. They are correct on my worksheet. Problem is both result boxes change colour instead of independently?

=OR((AND($C7="Anode Mother Roll",$Q7>1350)),(AND($C7="Cathode Mother Roll",$P7>520)),(AND($C7="Cathode Mother Roll",$Q7>520)))

=OR((AND($C7="Anode Mother Roll",$Q7<=1350)),OR(AND($C7="Cathode Mother Roll",$P7<=520)),OR(AND($C7="Cathode Mother Roll",$Q7<=520)))

 

[Special-K99]

"If Anode Mother Roll and result is <=1350 = green,>1350 = red
if Cathode Mother Roll and result is <=520 = green,>520 = red"

Which result are you referring to in the above, P or Q ?

 

[rmak85]

The above applies to both results as there are two testsdone.
For example,
Anode test, result 1 = 1300 (should turn green), Result 2 =1351 (should turn red)
Cathode test. Result 1 = 521 (should turn red), Result 2 =500 (should turn green)

However both results turn colour based on condition ofresult 2 (Q)

 

[Special-K99]

=OR(AND(C7="Anode Mother Roll",OR(P7<=1350,Q7<=520)) format as green

=OR(AND(C7="Cathode Mother Roll",OR(P7>520,Q7>1350)) format as red

 

[rmak85]

Im still unable to achieve the result. Here is the exampleim trying to achieve. Maybe I need to use the IF function?
True Green Statement
IF “anode mother roll” is <=1350 OR IF Cathode Motherroll is <=520

Something along these lines?
I just cant wrap my head round it.