How to Compare between cells and choose smallest value
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
|