Many thanks for the swift reply. Although your method does duplicate actions across sheets, I am unfortunately looking to link cells so that dependent cells automatically update themselves (just as they would with numbers). Can this be done with colour formatting??

thanks,