Help with Conditional Formatting in Excel 2010

Hello:

I am trying to get some conditional formating to work and I must be missing something.  I have 2 columns with % in them.  They want to add the 2 columns together and then highlight the top 3 in green.  BUT they don't want the total of the 2 % to show only the first 2 columns.

I didn't explain that very well, let me give an example:

Say this row is one of the top 3:

Row  35.4%  35.6%       The total would be 71% but they want the 35.4% and 35.6% to be shaded green and the 71% would just be a calculation used to determine the top 3.

I am attaching a file as an example.  It hopefuly makes more sense.

Thank you in advance.




 exampleTop3.xlsx
MeowserMAsked:
Who is Participating?
 
barry houdiniConnect With a Mentor Commented:
Hello MeowserM,

I selected the whole range A1:B21 and then used this formula in conditional formatting

=$A1+$B1>=LARGE(IF(ISNUMBER($A$1:$A$21+$B$1:$B$21),$A$1:$A$21+$B$1:$B$21),3)

see attached

regards, barry
26877400.xlsx
0
 
MeowserMAuthor Commented:
Barry -

You're awesome.  I didn't know the Large formula.

Thank you Thank you Thank you!

0
 
MeowserMAuthor Commented:
Thanks again
0
 
barry houdiniCommented:
No problem....

.....Oh, and I didn't mean to keep column G in there - that was just for testing purposes so you can delete that - only requires formula in conditional formatting....

barry
0
 
MeowserMAuthor Commented:
yes I didn't keep column G in the real spreadsheet.  

Much appreciated.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.