I want to use conditional formatting to format all the cells in one range that are greater than their corresponding cell in the 2nd range of data and those that are less than their corresponding cells another way. I can do this if I manually go through and do it one cell at a time but when I select the whole range of data I wish to apply the CF to it does not produce the desired results. For instance looking at the table below I would want the number present in Set 1 Group 1 Category 1 cell to be formatted based off the value in Set 2 Group 1 Category 1 cell and so on and so forth. Any help is greatly appreciated.
<tbody>
</tbody>
Set 1 | Set 2 | |||||||
Categories | Group 1 | Group 2 | Group 3 | Group 1 | Group 2 | Group 3 | ||
1 | 12 | 34 | 54 | 23 | 54 | 73 | ||
2 | 65 | 75 | 95 | 47 | 63 | 21 | ||
3 | 90 | 55 | 67 | 21 | 54 | 76 | ||
4 | 67 | 33 | 56 | 12 | 8 | 90 |
<tbody>
</tbody>