Copying cell colours
I need know if anyone can help me with how I can make one cell copy the fill
colour of another cell? i.e A/01 is turned Red I also want B/o1 to be Red A/01 is turned Red I also want A/05 to be Red Thank you in advance. |
Copying cell colours
One way:
Put this in your worksheet code module (right-click the worksheet tab and choose View Code): Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range) Range("B1,A5").Interior.ColorIndex = _ Range("A1").Interior.ColorIndex End Sub Note that the change won't take effect until you change the selected cell. If you're not familiar with macros, see http://www.mvps.org/dmcritchie/excel/getstarted.htm In article , Atomic wrote: I need know if anyone can help me with how I can make one cell copy the fill colour of another cell? i.e A/01 is turned Red I also want B/o1 to be Red A/01 is turned Red I also want A/05 to be Red Thank you in advance. |
All times are GMT +1. The time now is 06:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com