Highlighting the lowest cell automatically
 

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

Highlighting the lowest cell automatically
 

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