HI,
Is there a way to match formatting from a cell in a worksheet to another cell in a different worksheet? For example if A1 in worksheet 1 is red, I want cell B2 in worksheet 2 to automatically match and then if i change the colour of cell A1 I want cell B2 to automatically change?
Thanks