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.
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.
Summary: Hi, The formulas for conditional formatting that DerbyDad03 gave you do work in Excel 2007. Maybe you didn't enter them correctly. Excel 2007 has a load more options for conditional formatting than 20...
Summary: Silly me. Nowhere in the code was copy or paste. :) I see the "=" in the For Next loop. I just don't know the syntax to VB well at all. I can sort of deduce what's going on from what little coding...
0 
