CONDITIONALLY FORMAT A SPECIFIED NUMBER (BUT NOT ALL) OF ROWS MATCHING A NUMBER CRITERIA

[Mr_Phil]

I get two reports.
One is parts details
One is a summary that shows parts open for shipment.
I might have details on 30 parts but only 5 are ready to ship. \
So I want to highlight the first 5 of the 30 so I can quickly set up shipping.
Everytime I set down to do it I think I can countif it and it ends up all or nothing.
I've pulled out all my hair. Please take pity on a bald guy... Thank you very much for looking.

 

[Peter_SSs]

It is much easier to get helpers if you provide your sample data in a form that can be copied for testing.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this is what you want.

22 10 08.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2	PART	PART #	LOACATION						ITEM
3	Part A								Part A	1
4	Part A								Part B	4
5	Part B
6	Part B
7	Part B
8	Part B
9	Part B
10	Part B
11	Part B
CF Parts

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:C11	Expression	=COUNTIF($A$3:$A3,$A3)<=VLOOKUP($A3,$I$3:$J$10,2,0)	text	NO

 

[Mr_Phil]

It is much easier to get helpers if you provide your sample data in a form that can be copied for testing.
MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

See if this is what you want.

22 10 08.xlsm
	A	B	C	D	E	F	G	H	I	J
1
2	PART	PART #	LOACATION						ITEM
3	Part A								Part A	1
4	Part A								Part B	4
5	Part B
6	Part B
7	Part B
8	Part B
9	Part B
10	Part B
11	Part B
CF Parts

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
A3:C11	Expression	=COUNTIF($A$3:$A3,$A3)<=VLOOKUP($A3,$I$3:$J$10,2,0)	text	NO

Thank you for your help. I will be sure to install it and use it in the future.

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.