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.

	#1	#2	#3	#4	#5	#6	#7	#8	#9	#10
#1		44	32	####	46	397	76	141	126	53	#1
#2	38		25	####	31	280	54	100	74	44	#2
#3	17	17		####	13	175	28	63	55	16	#3
#4	####	####	####		####	####	####	####	####	####	#4
#5	29	25	13	####		193	38	75	78	25	#5
#6	803	511	373	####	355		376	1246	446	540	#6
#7	67	58	41	####	51	182		127	110	57	#7
#8	157	147	109	####	124	999	195		250	140	#8
#9	141	101	101	####	117	495	150	302		104	#9
#10	44	44	16	####	28	212	35	110	67		#10

<tbody>
</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.