Is there an easy way to format 1 or 2 cells in a range? For example, I have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G

Try making the condition for the format =MIN($a$1:$a$4). The $s may or may
not be a good idea. They have the usual effect of freezing or freeing
references as you copy the format.

"G" wrote:

Is there an easy way to format 1 or 2 cells in a range? For example, I have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G

Conditional formatting. Cell value is equal to =MIN($A$1:$A$4)

--
Ian
--
"G" wrote in message
...
Is there an easy way to format 1 or 2 cells in a range? For example, I
have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G

Jim/Ian,

Thanks, very helpful. One follow-up question ... would it be possible to
highlight the 2nd Lowest total? If so, how would I do that?

Thanks.

G

"Ian" wrote:

Conditional formatting. Cell value is equal to =MIN($A$1:$A$4)

--
Ian
--
"G" wrote in message
...
Is there an easy way to format 1 or 2 cells in a range? For example, I
have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G

=SMALL($A$1:$A$7,2) in place of the MIN function below.

--
Ian
--
"G" wrote in message
...
Jim/Ian,

Thanks, very helpful. One follow-up question ... would it be possible to
highlight the 2nd Lowest total? If so, how would I do that?

Thanks.

G

"Ian" wrote:

Conditional formatting. Cell value is equal to =MIN($A$1:$A$4)

--
Ian
--
"G" wrote in message
...
Is there an easy way to format 1 or 2 cells in a range? For example, I
have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if
there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G

Thanks, Ian, but this appears to get ONLY the two lowest. In the case of the
sample data (below), I only highlight the two 25s. I would like to highlight
the two 25s AND the 30. Any ideas?

Thanks.

G


"Ian" wrote:

=SMALL($A$1:$A$7,2) in place of the MIN function below.

--
Ian
--
"G" wrote in message
...
Jim/Ian,

Thanks, very helpful. One follow-up question ... would it be possible to
highlight the 2nd Lowest total? If so, how would I do that?

Thanks.

G

"Ian" wrote:

Conditional formatting. Cell value is equal to =MIN($A$1:$A$4)

--
Ian
--
"G" wrote in message
...
Is there an easy way to format 1 or 2 cells in a range? For example, I
have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if
there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G

Set 2 conditions. You can set up to 3 for each cell. If the 1st isn't
satisfied, it moves on to the second etc

--
Ian
--
"G" wrote in message
...
Thanks, Ian, but this appears to get ONLY the two lowest. In the case of
the
sample data (below), I only highlight the two 25s. I would like to
highlight
the two 25s AND the 30. Any ideas?

Thanks.

G


"Ian" wrote:

=SMALL($A$1:$A$7,2) in place of the MIN function below.

--
Ian
--
"G" wrote in message
...
Jim/Ian,

Thanks, very helpful. One follow-up question ... would it be possible
to
highlight the 2nd Lowest total? If so, how would I do that?

Thanks.

G

"Ian" wrote:

Conditional formatting. Cell value is equal to =MIN($A$1:$A$4)

--
Ian
--
"G" wrote in message
...
Is there an easy way to format 1 or 2 cells in a range? For
example, I
have
4 cells

A1 25
A2 30
A3 35
A4 25

I want to highlight the lowest cell number of the column in RED (if
there
are two, I want to highlight both of them.

Any help is welcome. Thanks.

G