Conditional formatting -per row- but over entire table

[CaraM]

What's the fastest/easiest way, in a table where I will be adding rows, to highlight the lowest value per row but for every row in the table?

In my table below, I want to highlight the lowest price per item - as in row 2. Do I have to use format painter and copy to each row individually, and remember to do this when I add new rows, too?

I tried changing the range for the conditional format to all the rows for columns B-F, but that highlights the lowest price in the table, not the row.

Grocery.xlsx
	A	B	C	D	E	F	G
1	Item	Walmart	Kroger	Aldi	Lidl	Target	Need?
2	Almond Milk	2.44		2.45		2.59	X
3	Wasa	3.63	4.09
4	Saltines	1.74
5	Animal *******s
6	Pita chips
7	Progresso soup	2.38	1.49
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F2	Cell Value	top 1 bottom values	text	NO

 

[Peter_SSs]

With the changed formula there should be no need to still check for blanks. Some other possible shortenings as well.

CaraM.xlsm
	A	B	C	D	E	F	G
1	Item	Walmart	Kroger	Aldi	Lidl	Target	Need?
2	Almond Milk	2.44		2.45		2.59	X
3	Wasa	3.63	4.09		2.85
4	Saltines	1.74
5	Animal *******s
6	Pita chips		2.23/oz		2.29/oz	2.23/oz
7	Progresso soup	2.38/pkt	1.49/pkt
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:F7	Expression	=--TEXTBEFORE(B2,"/",,,1)=MIN(IFNA(--(TEXTBEFORE($B2:$F2,"/",,,1)),"x"))	text	NO