View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default How to Compare between cells and choose smallest value

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.