Change cell color if it is the lowest number of a group?

A

Anthony

I was wondering how do you change the color of the number in a cell when that
number is the lowest number in a group of cells? Thanks in advance.

Anthony
 
D

Dave O

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

pinmaster

Hi,
Use conditional formatting and the MIN formula using these settings
Cell Value is:
Equal to:
and type your formula
e.g... =MIN($A$1:$B$10)
choose your format and hit OK.

HTH
JG
 
A

Anthony

Thanks, works great. I could not remember the Conditional Formatting in
Excel.

Anthony
 
Top