View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.newusers
J Sedoff comRemove> J Sedoff comRemove> is offline
external usenet poster
 
Posts: 42
Default How do I get the lowest number in a row to turn red in Excel ?

If you had your numbers in Column A from rows 1 to 8, like below:

A
1 1
2 5
3 4
4 2
5 6
6 7
7 8
8 0.5

Select those cells, starting from A1 (click and drag to A8, or holding down
the Shift key, use the arrow keys or click A8 with the mouse) and go to the
menu "Format" then "Conditional Formatting." For Condition 1, choose
"Formula Is" from the first drop-down menu, then type in "=MIN($A$1:$A$8)=A1"
without the quotes (make sure to keep the dollar signs so the range won't
change as the formula is evaluated at each cell, also make sure that after
the second equal sign you don't have a dollar sign so that the cell address
will change). Then press the "Format" button and choose the "Patterns" tab,
and whatever color you wish. Press "OK" and then again. In the example
above, the 0.5 cell should highlight to whatever color you choose in the
"Patterns" tab.

To modify this for your file, just change the range from $A$1:$A$8 to
whatever top-left to bottom-right cells you are interested in. And change
the A1 to whatever cell is selected as you go into the Conditional Formatting
screen.

Hope this helps, Jim
--
I appreciate any feedback. Please don''t be scared to say that "Yes,"
I/someone else did answer your question. Thank you.