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