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

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


"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

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


"Jonno" <(E-Mail Removed)> wrote in message
news:CC6BD7A0-DB2A-4D54-A41A-(E-Mail Removed)...
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
--
Jonno


"RagDyeR" wrote:

> 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!
> =====================================================
>
>
> "Jonno" <(E-Mail Removed)> wrote in message
> news:CC6BD7A0-DB2A-4D54-A41A-(E-Mail Removed)...
> 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
>
>
>

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Jonno" <(E-Mail Removed)> wrote in message
news:71FABF88-E4E1-4BE2-9C2B-(E-Mail Removed)...
> This worked perfect thank you very much
> --
> Jonno
>
>
> "RagDyeR" wrote:
>
> > 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!
> > =====================================================
> >
> >
> > "Jonno" <(E-Mail Removed)> wrote in message
> > news:CC6BD7A0-DB2A-4D54-A41A-(E-Mail Removed)...
> > 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
> >
> >
> >