Conditional Formatting: Highlight the lowest value

Hello

I wanted to ask for your help as all my searches on conditional formatting don't seem to return quite what I am after.

On the attached spreadsheet I am trying to get the conditional formatting to highlight the lowest value, comparing very specific cells:

For example on this spreadsheet:
To highlight the lowest value of these cells: G6, N6, U6, AB6, AI6

While ignoring the other values in that row and ignoring blanks and any cells with 0 in.

I would be very grateful if someone could advise. The only things I can find are formulas that compare and highlight values in the entire row.
I am using Excel 2000.

Thank you

Hello
Thank you for your help. I must be doing something wrong as I cannot get either suggestions to work.

When I try the first one it just highlights one of the zeros values in green ... I want it to highlight the lowest value which is over 0.

The second option just comes up with a box saying "the formula you typed contains an error".

All I did was select each of the cells I wanted to apply the formulas to at the same time then copy and paste the formula in. I have also tried adding it to each cell separately but I get the same result.

Any suggestions, I must be doing something wrong.

Thanks
Debbie

I have just tried:

Cel value is equal to:
=MIN(IF(G6>0,G6,9^9),IF(N6>0,N6,9^9),IF(U6>0,U6,9^9),IF(AB6>0,AB6,9^9),IF(AI6>0,AI6,9^9))

This is now highlighting the two lowest values (but over 0) in green. Any idea how to make it highlight just the lowest?

Thanks
xxxx

Ah, that file worked perfectly. Thank you. I knew Imust have been doing something wrong.

Thank you xxxx