How to Compare between cells and choose smallest value

  • Thread starter Thread starter Smallest value cell change color
  • Start date Start date
S

Smallest value cell change color

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
 
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.
 
Assume the range of cells is A1:D1

Select the range A1:D1
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 address removed)> wrote in message
news:[email protected]...
 
I would like to do this same function only I want to grab the three lowest
values. Any ideas?
 
......A.....B.....C.....D
1..22....15....29...30

=SMALL(A$1:D$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:D$1)>=ROWS(A$1:A1),SMALL(A$1:D$1,ROWS(A$1:A1)),"")
 
Back
Top