With your first possible cell active (D2 say), go to the menu and select
Format Conditional Formatting FormulaIs in box type =D2=Min($D$2:$D$10) Chg
to Suit
Choose Pattern, OK


"Robin" wrote:

Using Excel 2003. I can use the min function to find the lowest number in a
row but how do I get the lowest number in a row (or column) to change colour
so that it stands out?

Any help would be greatly appreciated.