Conditional Formatting Using OR

[lisa_swinton]

Hi
I'm trying to work out the best way to do this conditional formatting I believe it should be the OR function but I then want to add a condition based on another field

D15="Threat" then check the below conditions. I've tried =IF(D15="Threat")OR(X15+Q15<0,X15+T15<0) but no joy

=OR(X15+Q15<0,X15+T15<0)

 

[Joe4]

If this what you are looking for?

=AND(D15="Threat",OR(X15+Q15<0,X15+T15<0))

 

[lisa_swinton]

If this what you are looking for?

=AND(D15="Threat",OR(X15+Q15<0,X15+T15<0))

That worked thanks

 

[Joe4]

You are welcome!
Glad I as able to help.