I have a set of numbers in one tab(numbers from the week prior) of a worksheet and the exact statistics in a second tab(current numbers of the week) and want to compare the two associated tabs by taking the most recent tab's numbers and coloring the cell if it is greater than 10%, less than 10%, or no color if in between this variance. An Example of numbers is below:
Prior Week
12125 553 194734 54510 1630 1092 1318 68801098
Current Week
12127 555 39 194736 54390 1633 1092 1318 59976844
I have tried all sorts of ways to do this and just cannot get it right!
Thanks in advance!
Bookmarks