lowest number with a colr
 

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

lowest number with a colr
 

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.

--
Rick (MVP - Excel)


"israel" wrote in message
...
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.
--
smile