View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Biff
 
Posts: n/a
Default 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