I have 2 arrays that are 6 x 6. I would like to conditional format the cells in the first array based on whether the corresponding values in the second array are less than 15% (in green) or greater than or equal to 15% (in red). Below is an example of the 2 arrays. The first row is column labels in each array The first array is located at H2:M8. The second array is located at V2:AA8. A wrinkle, but not required, would be if the percentage is 0% in array 2, then the corresponding cells in array 1 would remain un-formatted. I have searched the web and haven't struck gold, short of creating 2 conditional formatting rules for each cell in the first array based on the corresponding value in the second array (72 rules!)
Thank you,
Bob
<tbody>
</tbody>
<tbody>
</tbody>
<tbody>
</tbody>
Thank you,
Bob
FCP1 | FCP1-2 | FCP1-3 | FCP1-4 | FCP1-5 | FCP1-6 |
$94,045.69 | $191,278.70 | $319,858.32 | $432,699.87 | $558,319.13 | $666,303.19 |
$0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
$27,230.28 | $57,828.63 | $91,347.81 | $123,487.03 | $156,320.82 | $189,571.23 |
$11,569.16 | $22,314.54 | $35,165.74 | $48,522.11 | $61,103.96 | $73,925.00 |
$198,074.58 | $248,835.31 | $637,667.82 | $872,446.90 | $1,112,233.06 | $1,340,813.76 |
$0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
<tbody>
</tbody>
FCP1 | FCP1-2 | FCP1-3 | FCP1-4 | FCP1-5 | FCP1-6 |
1.1% | 1.5% | 4.0% | 8.8% | 14.4% | 20.3% |
0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
2.0% | 3.9% | 9.4% | 15.6% | 23.1% | 30.0% |
8.9% | 11.3% | 17.8% | 25.7% | 32.6% | 38.7% |
2.4% | 3.7% | 4.2% | 8.1% | 13.5% | 19.1% |
0.0% | 0.0% | 0.0% | 0.0% | 0.0% | 0.0% |
<tbody>
</tbody>
<tbody>
</tbody>