Conditional formatting based on multiple cell criteria

[oreyoh]

I've been going at this for days...and I still can't get it right.

I'm trying to use conditional formatting so that:

Condition 1:
When A11 = PM&R 150 Days and D11 is < or = 150
OR When A11 = MLF 240 Days and D11 is < or = 240
The cell turns GREEN

Condition 2:
When A11 = PM&R 150 Days and D11 is > 150
OR When A11 = MLF 240 Days and D11 is > 240
The cell turns RED

Is this possible?
For Condition 2 I tried the formula:
=OR((AND(A19="PM&R 150 Days",D19>150)),(AND(A19="MLF 240 Days",D19>240)))

Am I close??? Or far off??
Please Help
Thanks in advance!

 

[repairman615]

Try This:

condition 1

=OR(AND($A$11="PM&R 150 Days",$D$11<=150),AND($A$11="MLF 240 Days",$D$11<=240))

condition 2

=OR(AND($A$11="PM&R 150 Days",$D$11>150),AND($A$11="MLF 240 Days",$D$11>240))

What is the A19 cell?


(edit..I think I see the list now...(a19))

 

[oreyoh]

Oh! A19 should be A11, I pasted the wrong item. Thanks for the code! I'm going to try this right away!

 

[oreyoh]

When I tried the code, the cell turned red, but should be green.
The scenario I had setup up was A11=PM&R 150 Days, D11=148 Days.

Any other suggestions? I think my original code is incorrect..I sort of just put them together...LOL

Thank you!!

 

[repairman615]

Hi,

In which cell are you conditionally formating?

 

[oreyoh]

I'm conditionally formating D11.

 

[repairman615]

In d11 you are going to have two rules for CF.

select d11
manage rules(make sure you are using a formula)

edit the rule that is there

1st rule is condition 1...copy and paste the code

format this rule to 'fill' green

click ok.

add a new rule
use formula
2nd rule is condition 2...copy/paste

format rule to 'fill' red

See if that helps.