Highlight a string based on a cell

[jrisebo]

How do I get col line B to 'conditionally format' based on col E?

Bolted Wood Connection.xlsm
	B	C	D	E
38	Z=2317.7 lbs			2317.7
39
40	Z=522.9 lbs			522.9
41
42	Z=760.53 lbs			760.53
43
44	Z=917.58 lbs			917.58
45
46	Z=427.73 lbs			427.73
47
48	Z=576.6 lbs			576.6
Sheet2

Cell Formulas
Range	Formula
B38	B38	=R15&C11*C13*C15/H30&R16
E38	E38	=C11*C13*C15/H30
B40	B40	=R15& ROUND(C11*C14*C16/H30,2)&R16
E40	E40	=ROUND(C11*C14*C16/H30,2)
B42	B42	=R15& ROUND(C27*C11*C14*C16/H31,2)&R16
E42	E42	=ROUND(C27*C11*C14*C16/H31,2)
B44	B44	=R15& ROUND(C28*C11*C13*C15/((1+2*H34)*H32),2)&R16
E44	E44	=ROUND(C28*C11*C13*C15/((1+2*H34)*H32),2)
B46	B46	=R15& ROUND(C29*C11*C14*C15/((2+H34)*H32),2)&R16
E46	E46	=ROUND(C29*C11*C14*C15/((2+H34)*H32),2)
B48	B48	=R15&ROUND(C11^2/H32*SQRT((2*C15*C12)/(3*(1+H34))),2)&R16
E48	E48	=ROUND(C11^2/H32*SQRT((2*C15*C12)/(3*(1+H34))),2)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E38:E48	Cell Value	top 1 bottom values	text	NO
B38:B48	Expression	="min($B$38:$B$48)"	text	NO
B38:B48	Other Type	Color scale		NO

 

[bebo021999]

CF formula for B38:B48

=$E48 = MIN($E$38:$E$48)

 

[jrisebo]

=$E48 = MIN($E$38:$E$48)

Im not getting that to work.
Maybe I am describing it wrong. I want to highlight the min value in B38 to B48, but they are strings, not numbers.

 

[bebo021999]

Like this?

Book1
	B	C	D	E
38	asd			2317.17
39
40	sdef			522.9
41
42	sdf			760.53
43
44	dfg			917.58
45
46	dgh			427.73
47
48	sdf			576.6
Sheet3

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B38:B48	Expression	=AND(E38<>"",E38=AGGREGATE(15,6,$E$38:$E$48/($E$38:$E$48<>0),1))	text	NO