Help Match Folders

So I am a bit of a newbie to Hazel but am loving all the possibilities...
I need help doing something. I have a folder structure like this:
PARENT FOLDER
I. Company 1
____II. folder1
____II. folder2
______III. folder x
______III. folder y
____II. folder3
I. Company 2
____II. folder1
____II. folder2
______III. folder x
______III. folder y
____II. folder3
this structure is repeated many times for many companies.
I need to create a rule that will scan all the subfolders in the parent folder, find subfolder that contains "folder2" in its name, and then apply tags to all files inside the subfolder and its subsubfolders...
I can't seem to figure out how to do it...
I have a "GOTOSUBFOLDER RULE" where it says IF kind IS folder THEN Run Rules on Folder Contents
then I have another rule that says IF kind IS Folder AND NAME contains "folder 2" THEN Run Rules on Folder Contents
and a third rule IF any file AND kind IS NOT folder THEN add TAG
but this tags everything in all folders...
so I guess the issue I can't limit the ADD TAG rule only to subfolders of a parent folder that contains "folder2"... I am sure it is possible to do, I just can't figure it out...
please help!
I need help doing something. I have a folder structure like this:
PARENT FOLDER
I. Company 1
____II. folder1
____II. folder2
______III. folder x
______III. folder y
____II. folder3
I. Company 2
____II. folder1
____II. folder2
______III. folder x
______III. folder y
____II. folder3
this structure is repeated many times for many companies.
I need to create a rule that will scan all the subfolders in the parent folder, find subfolder that contains "folder2" in its name, and then apply tags to all files inside the subfolder and its subsubfolders...
I can't seem to figure out how to do it...
I have a "GOTOSUBFOLDER RULE" where it says IF kind IS folder THEN Run Rules on Folder Contents
then I have another rule that says IF kind IS Folder AND NAME contains "folder 2" THEN Run Rules on Folder Contents
and a third rule IF any file AND kind IS NOT folder THEN add TAG
but this tags everything in all folders...
so I guess the issue I can't limit the ADD TAG rule only to subfolders of a parent folder that contains "folder2"... I am sure it is possible to do, I just can't figure it out...
please help!