Forum Discussion
Background color in Excel
The attached workbook demonstrates an approach using the Worksheet_Activate event procedure of Sheet 2. The colors will be updated when Sheet 2 is activated.
You will have to allow macros when you open the workbook.
To view/edit the code, right-click the sheet tab of Sheet 2 and select 'View Code' from the context menu.
Hi Hans
Thank you very much for your reply. Yes, the background color has been applied manually. So, when you say that it would be complicated - do you mean it's impossible? Or is there a way to make it work?
Will the formulas always be on another worksheet than the sheet with the 'source' cells?
Or could they be on the same sheet?
- HansVogelaar
Both are possible. - I can adapt the solution according to the possibilities.The attached workbook demonstrates an approach using the Worksheet_Activate event procedure of Sheet 2. The colors will be updated when Sheet 2 is activated.
You will have to allow macros when you open the workbook.
To view/edit the code, right-click the sheet tab of Sheet 2 and select 'View Code' from the context menu.
- Hi Hans Vogelaar
Thanks a lot!
I'm working a little further with your solution, but I think it will work.