View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default Change cell color if it is the lowest number of a group?

I used this formula in "Conditional Formatting" in cell B3:
=B3=MIN($B$3:$B$6)
.... and applied a distinctive cell format. Then I copied cell B3 and
pasted it into B4 to B6. Enter a series of numbers into B3 to B6 and
the lowest number shows the format you applied.