I am using Excel 2007. My data is illustrated in the table below.
I am trying to identify the highest percentage in each row, then format that cell, plus the cell next to it (on the left).
For example, in Row 1, since 24% is the highest value, I want to format E1 and D1. In Row 2, I want to format C2 and B2. In Row 3, I want to format G3 and F3.
I am not sure what formula to use for the conditional formatting. Thanks for any help anyone can give!
A B C D E F G 1 Text1 4 11% 9 24% 2 5% 2 Text2 13 34% 6 16% 2 5% 3 Text3 1 3% 11 29% 12 32%
Bookmarks