Guidance/Help to Highlight Cell contentts Based on Min/Max

V

Vince

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
 
P

Pete_UK

You should look into using conditional formatting (on the Format
menu). This allows you to change colour, font size, embolden etc,
depending on some condition (in your case Cell Value Is, =BEST). Try
it out.

Hope this helps.

Pete
 
T

Tanya

I agree, conditional formatting would be useful in this scenario, however I
would begin with the Min formula i.e at bottom of each column under cost
enter the formula =min(range:range) [note you need to place in your own range
i.e. B2:B10] this will then give you the answer to which is the lowest value
and under Format>Conditional Format select Equal to A11 {A11 being the cell
with the formula =MIN(B2:B10)
Hope this helps.

Tanya
 
Top