Conditional Formatting- MIN value in 2 diff columns

[gtd526]

Hello,
Using conditional formatting, how can I Highlight MIN value of 2 different cells in 2 different columns?
Thank you.

Data:
$H3 vs $P3, moving down

Grocery List.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
2	PRODUCT	BRAND	Type	PRICE	Size	Weight	Grocer	Cost/Piece	PRODUCT	BRAND	Type	PRICE	Size	Weight	Grocer	Cost/Piece
3	Coffee	Folgers	Instant	$8.99	12	oz	Publix	$0.75	Coffee	Folgers	Instant	$6.99	16	oz	BJs	$0.44
4	Chicken Strips	Tyson	Buffalo	$9.49	25	oz	Publix	$0.38	Chicken Strips	Tyson	Buffalo	$15.79	56	oz	BJs	$0.28
5	Milk	Publix	Milk	$3.95	1	gal	Publix	$3.95	Milk	Wesley Farms	Milk	$3.09	1	gal	BJs	$3.09
Publix vs BJ's

Cell Formulas
Range	Formula
D3:D5	D3	=INDEX(GroceryMaster!$F$3:$F$1048576, MATCH(1, ('Publix vs BJ''s'!$A3=GroceryMaster!$A$3:$A$1048576)*('Publix vs BJ''s'!$B3=GroceryMaster!$B$3:$B$1048576) * ('Publix vs BJ''s'!$C3=GroceryMaster!$C$3:$C$1048576)*('Publix vs BJ''s'!$G3=GroceryMaster!$G$3:$G$1048576), 0))
E3:E5	E3	=INDEX(GroceryMaster!$D$3:$D$104500, MATCH(1, ('Publix vs BJ''s'!$A3=GroceryMaster!$A$3:$A$1048576)*('Publix vs BJ''s'!$B3=GroceryMaster!$B$3:$B$1048576) * ('Publix vs BJ''s'!$C3=GroceryMaster!$C$3:$C$1048576)*('Publix vs BJ''s'!$G3=GroceryMaster!$G$3:$G$1048576), 0))
F3:F5	F3	=INDEX(GroceryMaster!$E$3:$E$104500, MATCH(1, ('Publix vs BJ''s'!$A3=GroceryMaster!$A$3:$A$1048576)*('Publix vs BJ''s'!$B3=GroceryMaster!$B$3:$B$1048576) * ('Publix vs BJ''s'!$C3=GroceryMaster!$C$3:$C$1048576)*('Publix vs BJ''s'!$G3=GroceryMaster!$G$3:$G$1048576), 0))
I3:K4	I3	=A3
L3:L5	L3	=INDEX(GroceryMaster!$F$3:$F$1048576, MATCH(1, ('Publix vs BJ''s'!$I3=GroceryMaster!$A$3:$A$1048576)*('Publix vs BJ''s'!$J3=GroceryMaster!$B$3:$B$1048576) * ('Publix vs BJ''s'!$K3=GroceryMaster!$C$3:$C$1048576)*('Publix vs BJ''s'!$O3=GroceryMaster!$G$3:$G$1048576), 0))
M3:M5	M3	=INDEX(GroceryMaster!$D$3:$D$104500, MATCH(1, ('Publix vs BJ''s'!$I3=GroceryMaster!$A$3:$A$1048576)*('Publix vs BJ''s'!$J3=GroceryMaster!$B$3:$B$1048576) * ('Publix vs BJ''s'!$K3=GroceryMaster!$C$3:$C$1048576)*('Publix vs BJ''s'!$O3=GroceryMaster!$G$3:$G$1048576), 0))
N3:N5	N3	=INDEX(GroceryMaster!$E$3:$E$104500, MATCH(1, ('Publix vs BJ''s'!$I3=GroceryMaster!$A$3:$A$1048576)*('Publix vs BJ''s'!$J3=GroceryMaster!$B$3:$B$1048576) * ('Publix vs BJ''s'!$K3=GroceryMaster!$C$3:$C$1048576)*('Publix vs BJ''s'!$O3=GroceryMaster!$G$3:$G$1048576), 0))
P3:P5,H3:H5	H3	=D3/E3
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[JoeMo]

1. Select all the cells in column H you want to conditionally format.
2. Home>Conditional Formatting>New Rule>Use a formula.
3. Formula is: =AND($H3<=$P3,$H3<>"",$P3<>"")
4. Choose format and click OK
5. Select all the cells in column P you want to conditionally format.
6. Home>Conditional Formatting>New Rule>Use a formula.
7. Formula is: =AND($P3<=$H3,$H3<>"",$P3<>"")
8. Choose format and click OK

 

[gtd526]

1. Select all the cells in column H you want to conditionally format.
2. Home>Conditional Formatting>New Rule>Use a formula.
3. Formula is: =AND($H3<=$P3,$H3<>"",$P3<>"")
4. Choose format and click OK
5. Select all the cells in column P you want to conditionally format.
6. Home>Conditional Formatting>New Rule>Use a formula.
7. Formula is: =AND($P3<=$H3,$H3<>"",$P3<>"")
8. Choose format and click OK

Thank you.

 

[JoeMo]

Thank you.

You are welcome - thanks for the reply.