Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 224
  • Last Modified:

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
0
MeowserM
Asked:
MeowserM
  • 3
  • 2
1 Solution
 
barry houdiniCommented:
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now