Conditional formating of tab colours not working as expected

I want the tab color to change from red to green when the user a) completes a cell content on a sheet that results in its referenced cell changing from 0 to 1 then b) returns to the main tab called "VAT101".
It all works except that the change only occurs when I click on the "Bank detail" tab instead of when I click on the "VAT101" tab. If I interchange the word "Company" with "Bank detail" in the code, the behaviour remains exactly the same. i.e it the colors still only change when I click on the "Bank detail" tab. Here is the code

Please Login or Register  to view this content.

Hello derekps98,

Welcome to the Forum.
You may want to have another read of the Forum Rules as it seems you overlooked the rule about code tags.
Anytime VBA code is posted you are required to use code tags.

Before getting help with your code, you need to edit your post to add the missing code tags. Simply highlight all of the VBA code then click on the button with the # symbol on it.

Hello derekps98,

Welcome to the Forum.

As Palmetto says:

Before getting help with your code, you need to edit your post to add the missing code tags. Simply highlight all of the VBA code then click on the button with the # symbol on it.

Unless you do that, you will most likely not receive any help.

Happy New Year guys!

Hello derekps98,

Delete all your Code and try it instead of any Sheet, in ThisWorkBook.

Please Login or Register  to view this content.