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
|