lowest number with a colr

  • Thread starter Thread starter israel
  • Start date Start date
I

israel

Hello everyone

How can I color a cell that is the lowest #. I had a formula but even cells
both get colored. I need strictly the lowest.

Example column A, B & C each has 200 rows I need strictly the cell with the
lowest
figure colored.
 
Select A1 through C200 starting with A1... the easiest way to do this is to
type A1:C200 in the Name Box (the type-in drop-down field at the left side
of the Formula Bar). Next, click on Format/Conditional Formatting on Excel's
menu bar. On the dialog box that appears, select Formula is from the first
drop-down and put this formula in the second (blank) field...

=A1=MIN($A$1:$C$200)

On the next dialog box that appears, click the Format button and then select
the Patterns tab, select a color you want the cell to be colored with, and
then OK your way back to the worksheet. The cell (or cells) with the lowest
value in it (them) will show that color.
 
Back
Top