Conditional formatting twist!

[Ultimate Selector]

Ok this has me in a bit of a quandary on how to format this table. See Example...
I want to format the 6 lowest which I have done no problem. (Yellow) I see that the color formatting did not show up on here.
6 lowest are the #3 with 1-2-5-10 ... 5 with 3 ... and 10 with 3

However, I now want to black out all the other numbers but those 6 in yellow.
How would I go about doing that?

Thanks in advance for any help on this!

Regards,
U.S.

<tbody>
[TD="class: xl66"][/TD]
[TD="class: xl72"]#1[/TD]
[TD="class: xl73"]#2[/TD]
[TD="class: xl73, width: 39"] #3 [/TD]
[TD="class: xl73, width: 39"]#4[/TD]
[TD="class: xl73, width: 39"]#5[/TD]
[TD="class: xl73, width: 39"]#6[/TD]
[TD="class: xl73, width: 39"]#7[/TD]
[TD="class: xl73, width: 39"]#8[/TD]
[TD="class: xl73, width: 39"]#9[/TD]
[TD="class: xl74, width: 39"]#10[/TD]
[TD="class: xl67, width: 39"][/TD]

[TD="class: xl83, width: 39"]#1[/TD]
[TD="class: xl81, width: 39"][/TD]
[TD="class: xl76, width: 39"]44[/TD]
[TD="class: xl76, width: 39"]32[/TD]
[TD="class: xl76, width: 39"]####[/TD]
[TD="class: xl76, width: 39"]46[/TD]
[TD="class: xl76, width: 39"]397[/TD]
[TD="class: xl76, width: 39"]76[/TD]
[TD="class: xl76, width: 39"]141[/TD]
[TD="class: xl76, width: 39"]126[/TD]
[TD="class: xl82, width: 39"]53[/TD]
[TD="class: xl69, width: 39"]#1[/TD]

[TD="class: xl68, width: 39"]#2[/TD]
[TD="class: xl77, width: 39"]38[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]25[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]31[/TD]
[TD="class: xl65, width: 39"]280[/TD]
[TD="class: xl65, width: 39"]54[/TD]
[TD="class: xl65, width: 39"]100[/TD]
[TD="class: xl65, width: 39"]74[/TD]
[TD="class: xl78, width: 39"]44[/TD]
[TD="class: xl69, width: 39"]#2[/TD]

[TD="class: xl68, width: 39"] #3 [/TD]
[TD="class: xl77, width: 39"]17[/TD]
[TD="class: xl65, width: 39"]17[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]13[/TD]
[TD="class: xl65, width: 39"]175[/TD]
[TD="class: xl65, width: 39"]28[/TD]
[TD="class: xl65, width: 39"]63[/TD]
[TD="class: xl65, width: 39"]55[/TD]
[TD="class: xl78, width: 39"]16[/TD]
[TD="class: xl69, width: 39"] #3 [/TD]

[TD="class: xl68, width: 39"]#4[/TD]
[TD="class: xl77, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl78, width: 39"]####[/TD]
[TD="class: xl69, width: 39"]#4[/TD]

[TD="class: xl68, width: 39"]#5[/TD]
[TD="class: xl77, width: 39"]29[/TD]
[TD="class: xl65, width: 39"]25[/TD]
[TD="class: xl65, width: 39"]13[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]193[/TD]
[TD="class: xl65, width: 39"]38[/TD]
[TD="class: xl65, width: 39"]75[/TD]
[TD="class: xl65, width: 39"]78[/TD]
[TD="class: xl78, width: 39"]25[/TD]
[TD="class: xl69, width: 39"]#5[/TD]

[TD="class: xl68, width: 39"]#6[/TD]
[TD="class: xl77, width: 39"]803[/TD]
[TD="class: xl65, width: 39"]511[/TD]
[TD="class: xl65, width: 39"]373[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]355[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]376[/TD]
[TD="class: xl65, width: 39"]1246[/TD]
[TD="class: xl65, width: 39"]446[/TD]
[TD="class: xl78, width: 39"]540[/TD]
[TD="class: xl69, width: 39"]#6[/TD]

[TD="class: xl68, width: 39"]#7[/TD]
[TD="class: xl77, width: 39"]67[/TD]
[TD="class: xl65, width: 39"]58[/TD]
[TD="class: xl65, width: 39"]41[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]51[/TD]
[TD="class: xl65, width: 39"]182[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]127[/TD]
[TD="class: xl65, width: 39"]110[/TD]
[TD="class: xl78, width: 39"]57[/TD]
[TD="class: xl69, width: 39"]#7[/TD]

[TD="class: xl68, width: 39"]#8[/TD]
[TD="class: xl77, width: 39"]157[/TD]
[TD="class: xl65, width: 39"]147[/TD]
[TD="class: xl65, width: 39"]109[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]124[/TD]
[TD="class: xl65, width: 39"]999[/TD]
[TD="class: xl65, width: 39"]195[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl65, width: 39"]250[/TD]
[TD="class: xl78, width: 39"]140[/TD]
[TD="class: xl69, width: 39"]#8[/TD]

[TD="class: xl68, width: 39"]#9[/TD]
[TD="class: xl77, width: 39"]141[/TD]
[TD="class: xl65, width: 39"]101[/TD]
[TD="class: xl65, width: 39"]101[/TD]
[TD="class: xl65, width: 39"]####[/TD]
[TD="class: xl65, width: 39"]117[/TD]
[TD="class: xl65, width: 39"]495[/TD]
[TD="class: xl65, width: 39"]150[/TD]
[TD="class: xl65, width: 39"]302[/TD]
[TD="class: xl64, width: 39"][/TD]
[TD="class: xl78, width: 39"]104[/TD]
[TD="class: xl69, width: 39"]#9[/TD]

[TD="class: xl71, width: 39"]#10[/TD]
[TD="class: xl79, width: 39"]44[/TD]
[TD="class: xl75, width: 39"]44[/TD]
[TD="class: xl75, width: 39"]16[/TD]
[TD="class: xl75, width: 39"]####[/TD]
[TD="class: xl75, width: 39"]28[/TD]
[TD="class: xl75, width: 39"]212[/TD]
[TD="class: xl75, width: 39"]35[/TD]
[TD="class: xl75, width: 39"]110[/TD]
[TD="class: xl75, width: 39"]67[/TD]
[TD="class: xl80, width: 39"][/TD]
[TD="class: xl70, width: 39"]#10[/TD]

</tbody>

 

[Peter_SSs]

From that, I don't understand what you are trying to do.

 

[Ultimate Selector]

From that, I don't understand what you are trying to do.

Just want the 6 lowest numbers to show and the rest blacked out, say in black.

However I just figured out my own solution. All I needed to do was just black fill the grid background and that took care of it.
The conditional format for the lowest 6 in yellow are then the only ones to show up in yellow highlight.

Thanks for responding tho! Much Appreciated!


I

 

[Peter_SSs]

Glad you got it sorted.