Finding and highlighting a row based on multiple cell values

Hello everyone,

I registered because of this and I would like to ask you for help, because I am approaching hopelessness.

Explanation of what I am trying to do:
In a CSV that contains a BOM of a certain product, there is a column called "State" containing a value, which describes whether the part (or an assembly) is serialized, or is obsolete. State '50' stands for a serialized part and state '80' stands for an obsolete part. Long story short - I would like to find a part, or an assembly that has a state of '80' and highlight a row containing a sub-assembly, which is one level higher than that.

So for clarity, this is a simplified BOM:
startpoint.PNG

This is an illustration to comprehend the level structure (this is not so easily done by hand in the real CSV - usually there are about 15 levels):
structure_illus.PNG

This is what I would love to achieve:
endresult.PNG

That way we would be able to back-check whether our assemblies do not accidentally contain obsolete parts, and if they do, this feature could help me tell which exact sub-assemblies are the problematic ones.

I hope I explained my problem clearly enough, if not, please let me know, I will clarify ASAP. Thank you very much in advance for any help!

I really don't like this in D2 but I'm having brain fog and I can't seem to get my head around a better formula:

Please Login or Register  to view this content.

I'll keep thinking ...

WBD

This is a little shorter:

Please Login or Register  to view this content.

WBD

Hey. A small change then:

Please Login or Register  to view this content.

I'm still sure there is a better way though

WBD

You removed a column from the sheet so it stopped working. Try this in C3:

Please Login or Register  to view this content.

WBD

Idle curiosity. You could also achieve this using a macro:

Please Login or Register  to view this content.

WBD