Highlight the row of cells you wish to format, then Format
ConditionalFormat CellValueIs EqualTo =MIN($A2:$F2) then select the
desired formatting......

Vaya con Dios,
Chuck, CABgx3



"Frances Holden" wrote:

Does anyone know if it possible to show which is the lowest amount in a
selection of cells automatically, for example i have six cells all with
different amounts in them lets say 1, 2, 3, 4, 5, 6. and i want the cell with
the lowest number in it to show in a different colour so it can be seen
easily for example 1 would show in red and all the other cells would stay
black