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.