Hi there
i have a long list of data, basically, from b3 to e3 there are 4 catagories: a date, total number, relevant number, percentage of relative number. then these 4 catagories repeat for 15 times (for each different month). after this i have calculated the total average percent, and then halved it. i want to select and highlight all the ones in each row that are below the halved average.
i have been doing this by selecting each row, conditional formatting, cells that are below then selecting the cell with the halved average (for egaxple, bq3). however, i have to do this for each row separately. i was wondering if there is a way to select the whole table (from b3: bq46) and have each row highlighted if it is below the corresponing value in BV (so b3:bp3 will highlight all below bq3, b4:bp4 will highlight all below bq4...)?
any help would be appreciated!
M SU DONORS JUN % C IM M SU DONORS JUL % C IM M SU DONORS AUG % C IM M SU DONORS SEP % C IM TOTAL AVE TOTAL AVE AVE% C IM
Jun-16 513 2 0.39% Jul-16 778 4 0.51% Aug-16 498 1 0.20% Sep-16 430 6 1.40% 30 4.29 113 8.07 1.46% 0.73%
May-16 937 2 0.21% Jun-16 513 2 0.39% Jul-16 778 1 0.13% Aug-16 498 8 1.61% 27 3.86 87 6.21 1.15% 0.58%
Apr-16 569 4 0.70% May-16 937 16 1.71% Jun-16 513 9 1.75% Jul-16 778 16 2.06% 70 10.00 134 9.57 1.76% 0.88%
Mar-16 603 5 0.83% Apr-16 569 7 1.23% May-16 937 12 1.28% Jun-16 513 21 4.09% 63 9.00 132 9.43 1.66% 0.83%
Feb-16 561 3 0.53% Mar-16 603 5 0.83% Apr-16 569 43 7.56% May-16 937 41 4.38% 84 12.00 179 12.79 2.22% 1.11%
Jan-16 307 9 2.93% Feb-16 561 7 1.25% Mar-16 603 12 1.99% Apr-16 569 7 1.23% 77 11.00 138 9.86 1.89% 0.94%
Dec-15 207 8 3.86% Jan-16 307 5 1.63% Feb-16 561 17 3.03% Mar-16 603 11 1.82% 69 9.86 144 10.29 1.98% 0.99%
Nov-15 797 4 0.50% Dec-15 207 1 0.48% Jan-16 307 16 5.21% Feb-16 561 16 2.85% 59 8.43 122 8.71 1.55% 0.77%
Oct-15 381 9 2.36% Nov-15 797 4 0.50% Dec-15 207 7 3.38% Jan-16 307 6 1.95% 66 9.43 146 10.43 1.84% 0.92%
Sep-15 287 3 1.05% Oct-15 381 5 1.31% Nov-15 797 6 0.75% Dec-15 207 2 0.97% 47 6.71 131 9.36 1.60% 0.80%
Aug-15 430 2 0.47% Sep-15 287 3 1.05% Oct-15 381 17 4.46% Nov-15 797 9 1.13% 56 8.00 119 8.50 1.34% 0.67%
Jul-15 767 5 0.65% Aug-15 430 1 0.23% Sep-15 287 8 2.79% Oct-15 381 5 1.31% 63 9.00 125 8.93 1.45% 0.72%
Jun-15 544 6 1.10% Jul-15 767 2 0.26% Aug-15 430 8 1.86% Sep-15 287 1 0.35% 39 5.57 109 7.79 1.18% 0.59%
May-15 528 6 1.14% Jun-15 544 1 0.18% Jul-15 767 6 0.78% Aug-15 430 4 0.93% 53 7.57 130 9.29 1.47% 0.73%
Apr-15 401 18 4.49% May-15 528 6 1.14% Jun-15 544 9 1.65% Jul-15 767 9 1.17% 56 8.00 112 8.00 1.20% 0.60%
Bookmarks