"Conditional Formatting"

[Marwan69]

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:

[TABLE="width: 182"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[/TR]
[TR]
[TD="align: right"]1[/TD]
[TD]Investment[/TD]
[TD]Allocation[/TD]
[/TR]
[TR]
[TD="align: right"]2[/TD]
[TD]Govnt Sukuk[/TD]
[TD]7.25%[/TD]
[/TR]
[TR]
[TD="align: right"]3[/TD]
[TD]Local Sukuk[/TD]
[TD]5.22%[/TD]
[/TR]
[TR]
[TD="align: right"]4[/TD]
[TD]Int'l Sukuk[/TD]
[TD]12.10%[/TD]
[/TR]
[TR]
[TD="align: right"]5[/TD]
[TD]Equity L & F[/TD]
[TD]11.94%[/TD]
[/TR]
[TR]
[TD="align: right"]6[/TD]
[TD]Mutual Fund[/TD]
[TD]4.64%[/TD]
[/TR]
[TR]
[TD="align: right"]7[/TD]
[TD]Money Market[/TD]
[TD]58.86%[/TD]
[/TR]
[TR]
[TD="align: right"]8[/TD]
[TD]Total[/TD]
[TD]100%[/TD]
[/TR]
</tbody>[/TABLE]

Many thanks,
Marwan

 

[Special-K99]

Select the range under Investment column

Conditional Formatting
New Rule
Use a formula to determine...

=RANK(B2,B$2:B$7)<=3

Format as required

 

[Marwan69]

Perfect mate....

Thanks.