|
copy color
Hello, I hope someone can help me. This may well be a very basic question but I am totally new to Excel. I want to know if I can have the color of a cell in sheet 1 change automatically if I change the color in the corresponding cell in sheet 2... Is this possible??? Waiting hopefully Hobpedlar -- hobpedlar ------------------------------------------------------------------------ hobpedlar's Profile: http://www.excelforum.com/member.php...o&userid=25516 View this thread: http://www.excelforum.com/showthread...hreadid=389569 |
Very difficult, as a colour change does not trigger any event.
You could create toolbar button that sets the colour and then auto-updates the linked cell. -- HTH RP (remove nothere from the email address if mailing direct) "hobpedlar" wrote in message ... Hello, I hope someone can help me. This may well be a very basic question but I am totally new to Excel. I want to know if I can have the color of a cell in sheet 1 change automatically if I change the color in the corresponding cell in sheet 2... Is this possible??? Waiting hopefully Hobpedlar -- hobpedlar ------------------------------------------------------------------------ hobpedlar's Profile: http://www.excelforum.com/member.php...o&userid=25516 View this thread: http://www.excelforum.com/showthread...hreadid=389569 |
Thanks bob, That sounds like it could do the trick. I will try it out and let you know. Cheers Hobpedlar -- hobpedlar ------------------------------------------------------------------------ hobpedlar's Profile: http://www.excelforum.com/member.php...o&userid=25516 View this thread: http://www.excelforum.com/showthread...hreadid=389569 |
Hold down <Ctrl and click in the tab for Sheet2.
This "groups" the sheets, meaning whatever you do to one, will be duplicated in the other. When finished, don't forget to "ungroup" by right clicking in a tab and choosing "ungroup sheets". Forgetting to do this could create havoc in your WB! -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "hobpedlar" wrote in message ... Hello, I hope someone can help me. This may well be a very basic question but I am totally new to Excel. I want to know if I can have the color of a cell in sheet 1 change automatically if I change the color in the corresponding cell in sheet 2... Is this possible??? Waiting hopefully Hobpedlar -- hobpedlar ------------------------------------------------------------------------ hobpedlar's Profile: http://www.excelforum.com/member.php...o&userid=25516 View this thread: http://www.excelforum.com/showthread...hreadid=389569 |
RD has also shown you a way to do it without extra code, but if like me you
would find the grouping and ungrouping an unnecessary chore, then here is a bit of code that you can assign to the button Sub SetCellColour() Application.Dialogs(xlDialogPatterns).Show Worksheets("Sheet2").Range(ActiveCell.Address) _ .Interior.ColorIndex = ActiveCell.Interior.ColorIndex End Sub -- HTH RP (remove nothere from the email address if mailing direct) "hobpedlar" wrote in message ... Thanks bob, That sounds like it could do the trick. I will try it out and let you know. Cheers Hobpedlar -- hobpedlar ------------------------------------------------------------------------ hobpedlar's Profile: http://www.excelforum.com/member.php...o&userid=25516 View this thread: http://www.excelforum.com/showthread...hreadid=389569 |
Thanks to all for th assistance. Will let you know how it goes. Cheers Hobpedlar -- hobpedlar ------------------------------------------------------------------------ hobpedlar's Profile: http://www.excelforum.com/member.php...o&userid=25516 View this thread: http://www.excelforum.com/showthread...hreadid=389569 |
| All times are GMT +1. The time now is 05:13 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com