VBA formatting does not change automatically

[Adile]

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

[Greg M]

Hi there,

Take a look at the attached version of your workbook and see if it does what you need.

It uses the following code:

Please Login or Register  to view this content.

Conditional formatting has been used in the lower portion of the worksheet to highlight (in red) situations where a name appears more than once in a column.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[Adile]

Hi Greg M,

Thanx for your help in this matter.
Your code is working and does what I need it to do in the lower portion of the worksheet. But in cells C6:BF102 the conditional formatting does not work any more.
If can you combine the first half of my code with your code to get it work? I don't know how to do that.

Adile

[Greg M]

Hi again,

The formatting performed by the VBA code appears to work correctly for me - i.e. if I enter "Exp" (without quotes) in Cell C6, the background colour of that cell changes to purple.

Are you sure that Events are enabled in your application? (Run your "aan" routine to enable them.)

Regards,

Greg M

[Adile]

Hi,

Greg I[m sorry, i dont know what i did wrong the first time but now it works.
even without running the aan routine.
thanks for your help!!!!

Adile

[Greg M]

Hi again,

Many thanks for your feedback - delighted to hear that everything is working correctly for you now.

Best regards,

Greg M