Hi,
I have a sheet that contains 3 rows of data. The top row contains benchmark data and the other two rows are results. The XL2BB is below.
I would like a macro to loop through the two results rows and highlight any cell (by using a different colour fill) that is 5% greater than the benchmark value in the same column.
Is this possible?
Thanks
I have a sheet that contains 3 rows of data. The top row contains benchmark data and the other two rows are results. The XL2BB is below.
I would like a macro to loop through the two results rows and highlight any cell (by using a different colour fill) that is 5% greater than the benchmark value in the same column.
Is this possible?
Thanks
Book1 | ||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | AA | AB | AC | AD | |||
56 | 162.98 | 6.54 | 24.93 | 135.92 | 16.05 | 148.57 | 6.14 | 24.18 | 134.73 | 16.33 | 24.74 | 142.71 | 18.23 | 24.35 | 124.67 | 13.21 | 30.31 | 132.60 | 19.87 | 26.45 | 128.94 | 13.14 | 17.02 | 162.17 | 19.31 | 243.00 | 115.00 | 46.85 | 51.10 | 2.05 | ||
57 | 156.75 | 6.75 | 23.22 | 130.63 | 15.10 | 145.38 | 6.88 | 21.15 | 128.08 | 14.98 | 22.78 | 137.58 | 16.97 | 21.35 | 119.03 | 12.61 | 29.77 | 113.72 | 16.32 | 18.18 | 117.40 | 11.67 | 25.40 | 191.27 | 22.59 | 168.00 | 149.00 | 50.00 | 50.00 | 0.00 | ||
58 | 157.75 | 6.75 | 24.22 | 120.63 | 14.10 | 145.38 | 7.88 | 21.15 | 129.08 | 13.98 | 22.78 | 137.58 | 16.97 | 21.35 | 129.03 | 22.61 | 29.77 | 113.72 | 26.32 | 18.18 | 113.40 | 11.67 | 21.40 | 191.27 | 25.59 | 162.00 | 149.00 | 51.00 | 53.00 | 0.00 | ||
Summary |