Tab colour to change automatically

[colin.dickson]

Hi all,

I've got the following code to change the tab colour when cell C14 changes to "Error", however it doesn't automatically change, you have to F2 & Enter on that cell before it changes the tab colour... any ideas?

Please Login or Register  to view this content.

[colin.dickson]

I forgot to say the cell colour changes via Conditional Formatting