Computing.Net > Forums > Office Software > Conditional Formatting in Excel 2007

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Conditional Formatting in Excel 2007

Reply to Message Icon

Name: DPdx
Date: August 10, 2009 at 20:45:11 Pacific
OS: Windows XP
Product: Microsoft Microsoft excel 2007 (pc)
Subcategory: Microsoft Office
Tags: excel, Conditional Formatting
Comment:

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.



Sponsored Link
Ads by Google

Response Number 1
Name: jon_k
Date: August 11, 2009 at 00:05:31 Pacific
Reply:

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


0

Response Number 2
Name: DerbyDad03
Date: August 11, 2009 at 05:15:12 Pacific
Reply:

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.


0

Response Number 3
Name: DPdx
Date: August 11, 2009 at 15:43:23 Pacific
Reply:

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


0

Sponsored Link
Ads by Google
Reply to Message Icon

Related Posts

See More







Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: Conditional Formatting in Excel 2007

Color formatting in Excel 2007 www.computing.net/answers/office/color-formatting-in-excel-2007/9486.html

unable to right click in Excel 2007 www.computing.net/answers/office/unable-to-right-click-in-excel-2007/9142.html

Tricky Transposing in Excel 2007 www.computing.net/answers/office/tricky-transposing-in-excel-2007/8297.html