.urgent help please

L

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
 
B

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
 
Top