Highlighting the lowest cell automatically

  • Thread starter Thread starter Frances Holden
  • Start date Start date
F

Frances Holden

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
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Highlight lowest price in a row. 6
Find the lowest number? 3
How to highlight the lowest valued cell in a column in Excel 2003 2
Highlight the lowest number - only if it does not equal another va 6
Assign points based on two conditions 1
How to bold lowest value 2
Excel How To Create A Min Formulas That Will Take The 4 Min Value In Ascending Order 4
Highlighting a cell 6

Back
Top