lisa_swinton
New Member
- Joined
- Sep 2, 2022
- Messages
- 15
- Office Version
- 365
- Platform
- Windows
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)
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)