Different Multiple Conditions for Conditional Formatting

[xirtam]

I'm having issues with figuring out this formula:

If location = M and Delivery time is 5 or less, cell needs to be red
If location = M and delivery time is 6 or more, cell needs to be green
If location = R and delivery time is 9 or less, cell needs to be red
if location = R and delivery time is 10 or more, cell needs to be green

The cells I'm trying to highlight red or green are the delivery days.

I'm completely lost as to how to do this. I could really use some help as to how I could do this.

Can this even be done with conditional formatting?

Delivery Time (Days)	Location (METRO/RURAL)
2	M
2	M
5	R
2	M
2	M
3	R
5	M
7	M
12	R
5	M
6	M
7	R
5	R
7	R
7	M
4	M
4	M

 

[kevin9999]

Book1
	A	B
1	Delivery Time (Days)	Location (METRO/RURAL)
2	2	M
3	2	M
4	5	R
5	2	M
6	2	M
7	3	R
8	5	M
9	7	M
10	12	R
11	5	M
12	6	M
13	7	R
14	5	R
15	7	R
16	7	M
17	4	M
18	4	M
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A2:A18	Expression	=AND($B2="R",$A2>=10)	text	YES
A2:A18	Expression	=AND($B2="R",$A2<=9)	text	YES
A2:A18	Expression	=AND($B2="M",$A2>=6)	text	YES
A2:A18	Expression	=AND($B2="M",$A2<=5)	text	YES

 

[xirtam]

I'm not sure what is wrong here, but some of them are not working??

 

[kevin9999]

Not sure why that would be - are you able to share your actual sheet using the XL2BB add in, or alternatively, share your actual file via Google Drive, DropBox or similar file sharing platform?

 

[xirtam]

Not sure why that would be - are you able to share your actual sheet using the XL2BB add in, or alternatively, share your actual file via Google Drive, DropBox or similar file sharing platform?

I’m not sure why it’s working now, but instead of having $F:$F I changed it to just the cells I needed and it worked.

Thank you very much for your help.

 

[kevin9999]

Happy to help & thanks for the feedback.