View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default Change Text Colour Of Lowest Value

hi
you can use conditional formating for this..
select cell A2 (or whatever you wish)
on the menu bar...
formatcoditional format.
Formula is......=A2=MIN(2:2).....pick your format.
then copy A2 and paste as formats across row 2 as far as you need.
this conditional format will look at all data in row 2 only.
you can then past as formats across row 3 and so on and the lowest value in
the row will be high lighted with your selected format.

Regards
FSt1


"Jonno" wrote:

Hi,
Below is a list of numbers and i need the lowest number of each row to show
up as red text. ie first row i want 36 to turn red, second row 2 to turn red.

Please could someone help????

36 37 38
12 93 2
85 48 21
2 52 5
32 5 6
21 12 5
12 1123 51

--
Jonno