Compare problem

rather than a picture can you load a sample sheet
Please upload a sample of your workbook to the forum, Make sure you have removed any private information, remember this is a public forum and so available to anyone
Would like to see an example of your data and also a manual mock up of the expected results you want to achieve.

To attach a file to your post,
click "Go advanced" (next to quick post),
scroll down until you see "manage Attachments",
click that and select "Choose File" (top Left corner).
Find your file, click "Open" click "upload" click 'close windows" Top Right. click "Submit Reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.

I imagine that someone will come along shortly and give you a simpler solution. Until then however:
Instead of writing a long formula I broke this down into several helper columns. The helper columns find the row of the first part number in each section, then the last row, then creates an index-able array of those rows in column F, then returns a 1 if the part number in column B is found in that array or a 0 if not. Next it creates an index-able array of those rows in column H, returns the amounts for the indexed parts found in column H and finally True or False based on whether that amount matches the amount in column A. The conditional formatting rule itself is a simple:

Please Login or Register  to view this content.

Here is the file with the formulas and rule applied: Copy of etn162743 index indirect CF.xlsx
Let me know if you have any questions.

Paste the following formula in E6 and copy down:

Please Login or Register  to view this content.

Here is a copy of the file from post #5 with the formula and conditional formatting applied: Copy of ETN162811.xls
Let me know if you have any questions.

Modify the formula for E6 and down as follows:

Please Login or Register  to view this content.

Add a conditional formatting rule =E6="None" (red).
Here is a copy of the the file with the modified formula and added rule applied: Copy of ETN162811.xls
Let me know if you have any questions.

Put the following formula in D2:

Please Login or Register  to view this content.

Select the range A2:A117 then put the following rule in conditional formatting (use a formula to determine which cells to format): =D2="Missing in BOM" (Pink)
Here is a copy of the file with the formula and rule applied: Copy of ETN162811.xls
Let me know if you have any questions.

Maybe these will be of help to you. Enter in D2 and fill down to check column A against column F

Formula:

Please Login or Register  to view this content.

To check column F against column A, enter this in K6 and fill down

Formula:

Please Login or Register  to view this content.