In Excel, I have 7 columns of data (numbers) spanning 100 rows. For each row, I want to check whether at least one number exceeds all other values by a certain value (say 0.2 or greater). If so, the row should be highlighted.
For example:
A B C D E F G
0.24 0.32 0.18 0.39 0.55 0.41 0.28 <-- Should not highlight
0.22 0.81 0.33 0.55 0.38 0.17 0.41 <-- Should highlight as column B exceeds all others by > 0.2
...
...
Given the number of possible combinations in each row, manually subtracting each column from all the others is not an ideal solution. Any ideas on a better way to tackle such a problem? I'm open to VBA solutions, although have little VBA experience myself.