Conditional Formatting in Excel 2007

August 10, 2009 at 20:45:11
Specs: Windows XP

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 5

I 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.


See More: Conditional Formatting in Excel 2007

Report •


#1
August 11, 2009 at 00:05:31

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 know

HTH


Report •

#2
August 11, 2009 at 05:15:12

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.


Report •

#3
August 11, 2009 at 15:43:23

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


Report •

Related Solutions


Ask Question