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.
|