If I have four cells, and I want the one with the smallest value change
color automatically.

Hi,

Select you 4 cells - in my case A1 - A4 then

Format|Conditional format
Formula is
=A1=MIN($A$1:$A$4)

Pick a colour and click OK

Mike

"Smallest value cell change color" wrote:

> If I have four cells, and I want the one with the smallest value change
> color automatically.

You can:
Select the range (say A1:B2)
format|conditional formatting (xl2003 menus)
formula is:
=a1=min($a$1:$b$2)

and give it a nice format.

Smallest value cell change color wrote:
>
> If I have four cells, and I want the one with the smallest value change
> color automatically.

--

Dave Peterson

Assume the range of cells is A11

Select the range A11
Goto the menu Format>Conditional Formatting
Formula Is:

=AND(A1<>"",A1=MIN($A$1:$D$1))

Click the Format button
Select the style(s) desired
OK out

--
Biff
Microsoft Excel MVP


"Smallest value cell change color" <Smallest value cell change
(E-Mail Removed)> wrote in message
news:4E9E8ECA-F14F-4D6A-88D5-(E-Mail Removed)...
> If I have four cells, and I want the one with the smallest value change
> color automatically.

I would like to do this same function only I want to grab the three lowest
values. Any ideas?

"Smallest value cell change color" wrote:

> If I have four cells, and I want the one with the smallest value change
> color automatically.

......A.....B.....C.....D
1..22....15....29...30

=SMALL(A$1$1,ROWS(A$1:A1))

Copy down a total of 3 cells.

Note that if there aren't at least N numbers in the range you'll get errors.

This formula makes sure there are enough numbers:

=IF(COUNT(A$1$1)>=ROWS(A$1:A1),SMALL(A$1$1,ROWS(A$1:A1)),"")

--
Biff
Microsoft Excel MVP


"jerminski73" <(E-Mail Removed)> wrote in message
news:5C1175DD-B4D8-4B2F-B396-(E-Mail Removed)...
>I would like to do this same function only I want to grab the three lowest
> values. Any ideas?
>
> "Smallest value cell change color" wrote:
>
>> If I have four cells, and I want the one with the smallest value change
>> color automatically.