Hi: I'm trying to highlight the larger of two data columns side by side on the same sheet.
ie:
a1 3 b1 4
a2 6 b2 5I want the larger of the two highlighted. (4 & 6) I can't get conditional formatting to select the larger of the two and color in that cell.
use a formula: =A1=MAX($A1:$B1) then copy/paste special (formats) all the
way down the rest of your data.Note if two values are the same, it will highlight both. If this is
not what you want, let me knowHTH
Or... Select A1:A2
Conditional Formatting...Formula Is: =IF(A1>B1,TRUE,FALSE)Select B1:B2
Conditional Formatting...Formula Is: =IF(B1>A1,TRUE,FALSE)Matching values will not be highlighted.
By selecting all the cells in a range and using Relative Addressing, the Conditional Formatting formula will adjust for each cell.
Thank you for your responses. I must confess I had only a slight clue about what I was doing, but with your help I was able to get it to do what I was looking for. Thanks again..
DB
