Matching Formatting using a formula

[Ugeeta]

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

 

[pecoflyer]

How are the cells colored? Manually or as the result of conditional formatting?

 

[Ugeeta]

The cells are manually colored.

 

[S. Das]

@Ugeeta, can you please upload a sample file stating clearly what you want (eg: cells, color, coloring process etc)