Hi Guys,

I have A file with Formatting done by VBA.
IF I use a name in a cel, and that is in folder "dienstkleur" the cel wil be formatted.

In this sheet (Per5) i have two sections. section where I write the names "C6:BF102".
and a section ''C104:BF123" where i automatically check if the names in B104:B123 are used 2 times or not at all in a row.

If the names are used two times the cel should be red. if it is not used at all the color should change automatically to orange.
but this will not work in my file. can somebody check my file and find out what i should add to my VBA code to get it work?

https://www.dropbox.com/s/5ooh6wxg8q...1%29.xlsm?dl=0

Thanks in advance

Adile