Today, I went shopping for best price for a gallon of heating oil, and
poked the quoted prices for 200, 300, 400, and 500 gallons planned
purchase into my existing XLS spreadsheet.

Today's collected data is organized like this:

Col A Col B Col C Col D Col E Col F
Col G Col H Col I Col J Col K
Row1 Vendor Phone # blank 200 200 Cost 300
300 Cost 400 400 Cost 500 500 Cost
Row2 3.699 $739.80 3.679
$1,103.70 3.659 $1,463.60 3.599 $1,799.50
Row3 3.619 $723.80 3.609
$1,082.70 3.609 $1,443.60 3.589 $1,794.50
Row4 3.519 $703.80 3.509
$1,052.70 3.509 $1,403.60 3.499 $1,749.50
Row5 3.539 $707.80 3.519
$1,055.70 3.499 $1,399.60 3.479 $1,739.50
Row6 3.349 $669.80 3.349
$1,004.70 3.349 $1,339.60 3.349 $1,674.50
Row7 3.699 $739.80 3.679
$1,103.70 3.659 $1,463.60 3.599 $1,799.50
Row8 3.499 $699.80 3.489
$1,046.70 3.489 $1,395.60 3.489 $1,744.50
Row9 3.449 $689.80 3.429
$1,028.70 3.429 $1,371.60 3.409 $1,704.50
Row10 3.599 $719.80 3.589
$1,076.70 3.589 $1,435.60 3.569 $1,784.50
Row11 3.509 $701.80 3.509
$1,052.70 3.579 $1,431.60 3.579 $1,789.50
Row12 3.509 $701.80 3.509
$1,052.70 3.579 $1,431.60 3.579 $1,789.50
Row13 3.749 $749.80 3.699
$1,109.70 3.699 $1,479.60 3.649 $1,824.50
Row14 3.699 $739.80 3.679
$1,103.70 3.659 $1,463.60 3.599 $1,799.50
Row15
..
..
..
Row22 BEST $ Price: 3.349 3.349
3.349 3.349

I have identified the best quoted price using the formula:
=MIN(D2:D17) which is copied into F22, H22, and J22.

Should I "NAME" the cell(s) that contains the BEST $ Price result,
because sometime in the future I most likely will want to do some
charting based on the collected data, since I track the same vendors
when shopping for best available heating fuel price based on quantity
of purchased gallons?

Is there a function that I could use to locate and highlight the
cell(s) that contain the BEST $ Price value(s)? In this particular
shopping instance, there is more than one cell that contains the "Best
$ Price" result. The highlighting can be a blinking cell or a choosen
color or perhaps change the font size/make bold for the target cell to
one that is larger than all others.

I hope that the above displays properly. This is my first attempt at
posting this info to the NG. Thanks.

Regards,
Vince
Long Island, NY