Change Text Colour Of Lowest Value

[Jonno]

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

 

[FSt1]

hi
you can use conditional formating for this..
select cell A2 (or whatever you wish)
on the menu bar...
format>coditional 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

 

[RagDyeR]

Select A1 to C7, with the focus on A1 (colored white).

Then, from the Menu Bar:
<Format> <Conditional Formatting>

Change "Cell Value Is" to "Formula Is", and enter:

=AND(A1=MIN($A1:$C1),A1<>"")

Then, click on "Format" and choose your Red font,
Then <OK> <OK>,

And you should be done!
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


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]

This worked perfect thank you very much

 

[Ragdyer]

You're very welcome, and your feed-back is appreciated.