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

Ask Your Question

Weekly Poll

What do you think of Volkswagen's diesel settlement?

Discuss in The Lounge

Poll History