It just have to look through the whole sheet, it dont have to start at row 3 especially.
In the real document, there are many blocks of data.

Just when he sees "inactieve", he has to make that line yellow, and 2 lines up -> also yellow.
When he made that line yellow, that line also needs "1" in column (A)

The document you sent me with the code, is nearly what i want!

Hope you can change it a little bit.