.urgent help please

[Laura \( '_' \)]

Hiya, Im very new to this.
I have a spreadsheet, with 6 different numbers in column 6.
I would like excel to highlight the lowest one(s).
I know there must be a simple way 2 do this.
any help would be gratefully received.
Thanks in advance
--
\m/ O_O \m/
Laura.....
Liverpool, England

[bobocat]

You can use condition formatting
in one of the cell
format->conditional formatting
condition1:
Cell value is equal to =min($a$1:$f$100)
set format to what ever you want
then copy the format to rest of the cell


"Laura ( '_' )" <busyday@the.office> 撰寫於郵件新聞:OwcD2vBnGHA.3656@TK2MSFTNGP03.phx.gbl...
>
> Hiya, Im very new to this.
> I have a spreadsheet, with 6 different numbers in column 6.
> I would like excel to highlight the lowest one(s).
> I know there must be a simple way 2 do this.
> any help would be gratefully received.
> Thanks in advance
> --
> \m/ O_O \m/
> Laura.....
> Liverpool, England
>
>

[Laura \( '_' \)]

thankyou bobocat, that was perfect!
(and very fast reply!! i'm impressed)

--
\m/ O_O \m/
Laura.....
Liverpool, England

"bobocat" <bobo.catgod@gmail.com> wrote in message
news:Ok4CG3BnGHA.3580@TK2MSFTNGP03.phx.gbl...
> You can use condition formatting
> in one of the cell
> format->conditional formatting
> condition1:
> Cell value is equal to =min($a$1:$f$100)
> set format to what ever you want
> then copy the format to rest of the cell
>
>
> "Laura ( '_' )" <busyday@the.office>
撰寫於郵件新聞:OwcD2vBnGHA.3656@TK2MSFTNGP03.phx.gbl...
> >
> > Hiya, Im very new to this.
> > I have a spreadsheet, with 6 different numbers in column 6.
> > I would like excel to highlight the lowest one(s).
> > I know there must be a simple way 2 do this.
> > any help would be gratefully received.
> > Thanks in advance
> > --
> > \m/ O_O \m/
> > Laura.....
> > Liverpool, England
> >
> >
>
>