How to highlight the lowest valued cell in a column in Excel 2003
 

I want to highlight the the lowest value cell in a column. How do I do this?
I want to highlight the cell only if one cell in the column has this value.
Also at the end of all the columns and rows total at the end of each row the
number of highlighted cells in that row. If more than one cell in the column
has the lowest value do not highlight. The easiest way for me to explain it
would be on a golf scorecard if you play golf and are doing a skins game and
for each hole you circle the the lowest score for each hole. If there is no
lowest score it carries over to the next hole. If on the next hole there is
one low score it is circled plus any carry over columns before it would be
circled on that same row.

How to highlight the lowest valued cell in a column in Excel 2003
 

We will use conditional formatting with two criteria:
1. the cell must contain the minimum value
2. the value cannot appear more than once

Select the top cell in the column, say column B and:

Format Conditional Formatting... FormulaIs

=AND(B1=MIN(B:B),COUNTIF(B:B,B1)<2) and pick a nice color

then copy the format down the column.
--
Gary''s Student - gsnu200819


"mapesii" wrote:

I want to highlight the the lowest value cell in a column. How do I do this?
I want to highlight the cell only if one cell in the column has this value.
Also at the end of all the columns and rows total at the end of each row the
number of highlighted cells in that row. If more than one cell in the column
has the lowest value do not highlight. The easiest way for me to explain it
would be on a golf scorecard if you play golf and are doing a skins game and
for each hole you circle the the lowest score for each hole. If there is no
lowest score it carries over to the next hole. If on the next hole there is
one low score it is circled plus any carry over columns before it would be
circled on that same row.

How to highlight the lowest valued cell in a column in Excel 2
 

Thank you for the direction.

"Gary''s Student" wrote:

We will use conditional formatting with two criteria:
1. the cell must contain the minimum value
2. the value cannot appear more than once

Select the top cell in the column, say column B and:

Format Conditional Formatting... FormulaIs

=AND(B1=MIN(B:B),COUNTIF(B:B,B1)<2) and pick a nice color

then copy the format down the column.
--
Gary''s Student - gsnu200819


"mapesii" wrote:

I want to highlight the the lowest value cell in a column. How do I do this?
I want to highlight the cell only if one cell in the column has this value.
Also at the end of all the columns and rows total at the end of each row the
number of highlighted cells in that row. If more than one cell in the column
has the lowest value do not highlight. The easiest way for me to explain it
would be on a golf scorecard if you play golf and are doing a skins game and
for each hole you circle the the lowest score for each hole. If there is no
lowest score it carries over to the next hole. If on the next hole there is
one low score it is circled plus any carry over columns before it would be
circled on that same row.