JohnyG
10-30-2008, 11:46 PM
Hi,
I have two sheets Sheet1 and Sheet2. The requirement is such that I need to enter values in Sheet1 and basis the values entered in sheet1 the cells in sheet2 get colored.
for instance
I have entered "2" in Sheet1!A2 as a result 2 columns starting from Sheet2!A2 i.e. (Sheet2 cell B2 and C2) get highlighted(colored).
Similarly if I entered "3" in Sheet1!A3 as a result 3 columns starting from Sheet3!B3 i.e. (Sheet2 cell B3, C3 and D3) get highlighted(colored).
Regards,
Johny
I have two sheets Sheet1 and Sheet2. The requirement is such that I need to enter values in Sheet1 and basis the values entered in sheet1 the cells in sheet2 get colored.
for instance
I have entered "2" in Sheet1!A2 as a result 2 columns starting from Sheet2!A2 i.e. (Sheet2 cell B2 and C2) get highlighted(colored).
Similarly if I entered "3" in Sheet1!A3 as a result 3 columns starting from Sheet3!B3 i.e. (Sheet2 cell B3, C3 and D3) get highlighted(colored).
Regards,
Johny