.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

 

[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 \( '_' \)]

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