Hey, thanks for the quick reply.

I've done exactly as you've said, however it's not gave me the result
expected.

Basically this is what my "test" spreadsheet consists of

- A | B | C
________________
1 | Dave 3
2 | Sarah 2
3 | Chris 23

I selected B1, then clicked "Format" - Conditional Formatting.

Selected "Formula is" on the first drop down box, then typed i
=MIN(B1:B3)

Then I clicked teh "format" button, and selected the pattern to yellow
Basically, this just gave B1 a yellow background.

Obviously B1 isn't the lowest number. Where've I cocked up? lol I
looks like it _should_ work to me

--
Viso
-----------------------------------------------------------------------
Visor's Profile: http://www.excelforum.com/member.php...fo&userid=3658
View this thread: http://www.excelforum.com/showthread.php?threadid=56327