Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cell Colours | Excel Discussion (Misc queries) | |||
Cell colours not showing | Excel Discussion (Misc queries) | |||
Count If on colours in a cell? | Excel Discussion (Misc queries) | |||
Excel 2003 font colours and cell colours | Excel Discussion (Misc queries) | |||
How to set different font colours in a cell? | Excel Worksheet Functions |