Changing tab color based on cell value

Hi guys, I wonder if any one here can help me.

I have a sheet that alerts me if any new customers have appeared in our database. My problem is I have to manually check this worksheet to see if anything new has appeared.

I thought the best way to resolve this would to create a macro that will change the tab color based on the value of a cell. The code below works in the sense that if the cell value is "refreshed" (sorry I don't the correct term) manually by me selecting the cell and hitting enter, the tab color changes. It however is not doing this off its own back, which is why I implement it in the first place.

The following code is in the sheet code, not a seperate module;

Please Login or Register  to view this content.

Can any one advise where I am going wrong?

Many thanks!

Prize,
You left out the "Target" which is the triggering range for the code to work automatically. Which column/row need to be changed inorder for the tab colour to change. Is it column B?

You can also try this code

Please Login or Register  to view this content.

Originally Posted by AB33

You can also try this code

Please Login or Register  to view this content.

The first code just replaced the formula in cell B4 with the value of 2. Gonna try the second code now.

Sorry Prize! It was my mistake.Please replace value by column. I have also amended my post