troubleshooting Question

Help with Conditional Formatting in Excel 2010

Avatar of MeowserM
MeowserM asked on
Microsoft Excel
5 Comments1 Solution255 ViewsLast Modified:
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
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 5 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 5 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros