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