Hello everyone,
I have a table(Below) and would like to assign a conditional formatting to the items under the allocation section, provided that the Investment section items should also have the same color or different doesn't really matter. I did the allocation section by clicking in: Conditional Format>Top/Bottom Rules...>Top 10 Items. And I chose Top 3.
It did the job, however, I want also the items under the investment section have the same format as the allocation. The table is below:
<tbody>
</tbody>
Many thanks,
Marwan
I have a table(Below) and would like to assign a conditional formatting to the items under the allocation section, provided that the Investment section items should also have the same color or different doesn't really matter. I did the allocation section by clicking in: Conditional Format>Top/Bottom Rules...>Top 10 Items. And I chose Top 3.
It did the job, however, I want also the items under the investment section have the same format as the allocation. The table is below:
A | B | |
1 | Investment | Allocation |
2 | Govnt Sukuk | 7.25% |
3 | Local Sukuk | 5.22% |
4 | Int'l Sukuk | 12.10% |
5 | Equity L & F | 11.94% |
6 | Mutual Fund | 4.64% |
7 | Money Market | 58.86% |
8 | Total | 100% |
<tbody>
</tbody>
Many thanks,
Marwan
Last edited: