conditional formatting or formula
 

Hello
I have two colums of numbers with one number always being higher than the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever number is
highest per row. Tried conditional format but this didnot work.
Many thanks

conditional formatting or formula
 

Hi!

Try this:

Assume your data is in the range A1:B4

Select the range A1:B4
Goto FormatConditional Formatting
Formula Is: =A1=MAX($A1:$B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"CJRolls" wrote in message
...
Hello
I have two colums of numbers with one number always being higher than the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever number is
highest per row. Tried conditional format but this didnot work.
Many thanks

conditional formatting or formula
 

I tried as you wrote but nothing happens. What do I need in the first drop
down boxes

"Biff" wrote:

Hi!

Try this:

Assume your data is in the range A1:B4

Select the range A1:B4
Goto FormatConditional Formatting
Formula Is: =A1=MAX($A1:$B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"CJRolls" wrote in message
...
Hello
I have two colums of numbers with one number always being higher than the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever number is
highest per row. Tried conditional format but this didnot work.
Many thanks

conditional formatting or formula
 

Assume your range is A1:B4

Select the range starting in cell A1 to B4. Cell A1 is the active cell. Its
background color is still white while the other cells that are selected are
"blueish".

Goto FormatConditional Formatting
From the first drop down select Formula Is
In the box to the right enter this exact formula:

=A1=MAX($A1:$B1)

The placement of the $ signs is very important!

Click the format button
Select the style(s) desired
OK out

Biff

"CJRolls" wrote in message
...
I tried as you wrote but nothing happens. What do I need in the first drop
down boxes

"Biff" wrote:

Hi!

Try this:

Assume your data is in the range A1:B4

Select the range A1:B4
Goto FormatConditional Formatting
Formula Is: =A1=MAX($A1:$B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"CJRolls" wrote in message
...
Hello
I have two colums of numbers with one number always being higher than
the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever number
is
highest per row. Tried conditional format but this didnot work.
Many thanks

conditional formatting or formula
 

Exactly what I needed Biff.
Thanks very much for your persistance with my problem. Greatly appreciated

CJRolls

"Biff" wrote:

Assume your range is A1:B4

Select the range starting in cell A1 to B4. Cell A1 is the active cell. Its
background color is still white while the other cells that are selected are
"blueish".

Goto FormatConditional Formatting
From the first drop down select Formula Is
In the box to the right enter this exact formula:

=A1=MAX($A1:$B1)

The placement of the $ signs is very important!

Click the format button
Select the style(s) desired
OK out

Biff

"CJRolls" wrote in message
...
I tried as you wrote but nothing happens. What do I need in the first drop
down boxes

"Biff" wrote:

Hi!

Try this:

Assume your data is in the range A1:B4

Select the range A1:B4
Goto FormatConditional Formatting
Formula Is: =A1=MAX($A1:$B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"CJRolls" wrote in message
...
Hello
I have two colums of numbers with one number always being higher than
the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever number
is
highest per row. Tried conditional format but this didnot work.
Many thanks

conditional formatting or formula
 

You're welcome. Thanks for the feedback!

Biff

"CJRolls" wrote in message
...
Exactly what I needed Biff.
Thanks very much for your persistance with my problem. Greatly appreciated

CJRolls

"Biff" wrote:

Assume your range is A1:B4

Select the range starting in cell A1 to B4. Cell A1 is the active cell.
Its
background color is still white while the other cells that are selected
are
"blueish".

Goto FormatConditional Formatting
From the first drop down select Formula Is
In the box to the right enter this exact formula:

=A1=MAX($A1:$B1)

The placement of the $ signs is very important!

Click the format button
Select the style(s) desired
OK out

Biff

"CJRolls" wrote in message
...
I tried as you wrote but nothing happens. What do I need in the first
drop
down boxes

"Biff" wrote:

Hi!

Try this:

Assume your data is in the range A1:B4

Select the range A1:B4
Goto FormatConditional Formatting
Formula Is: =A1=MAX($A1:$B1)
Click the Format button
Select the desired style(s)
OK out

Biff

"CJRolls" wrote in message
...
Hello
I have two colums of numbers with one number always being higher
than
the
other.
A B
2 3
1 4
3 1
5 0 and so on.
What I need to do is somehow change the font colour of whichever
number
is
highest per row. Tried conditional format but this didnot work.
Many thanks