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.