View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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