Conditional formatting

[pra_vee]

Hi All, I have a requirement in Excel. sheet 2,3,4 contains different company's data and sheet 1 is all data combined of sheet 2,3,4.now if i update any cell in the sheets 2 or 3 or 4 with a color i need the same to reflect in the master data tab automatically .Is that achievable through vba only or conditional formatting also ?? Thanks.

 

[Marc L]

Hi, as Conditional Formatting means for example the cell color can change under a condition on value​

so if sheets #2 to 4 have such CF to update colors then just reproduce the same CF in sheet #1 …​

But if there is no CF as you change the color manually, so proceed the same way.​

Or you already have a VBA procedure to create sheet #1 according to sources sheets​

so if it is not coded by foot the colors are kept …​

​