That is more helpful. Still not 100% certain on your setup but ill make some assumptions and you can modify to fit your environment.
I am assuming CK has a folder on it called Clients. Within the Client folder each Client has a folder (ie Client 1, Client 2, etc). Within each Client folder you have a Jobs folders (Job A, Job B, Job C). Within each Job folder, you will have a Design, Proofs, and Art folders.
You only need to run the rules on one folder, the main Clients folder.
Rules, in the following order:
Rule 1
If name contains Design
Set color label to Red
Rule 2
If name contains Proofs
Set color label to Blue
Rule 3
If name contains Art
Set color label to Green
Rule 4
If kind is folder
Run rules on subfolders
That should work. The subfolder rule needs to be last otherwise it will match the on the different subfolders and hazel will stop.