Macro - Place number & color when find word "inactieve"

Attached is an attempt, let me know if it is what you are after or if you need it changed.

I have assumed that the data starts on row 3 but highlighted the 2 lines of code where this can be changed to suit. Also I used the yellow in your example to colour the rows but again highlighted in the code where this can be changed. The last assumption I made (I know, I make a lot of assumptions), is that the data in your actual worksheet is in a large table which does not have a space between each line, if this is wrong let me know and I can modify the code slightly to make it work.

Mowgli

Werkmap1 RevA.xlsm