| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Detecting particular BG Color in one cell and duplicate it in anot
Excel 2007....I have two worksheets where I need to detect a particular cell
background color in one of the worksheets and duplicate in another (not the same formated sheet). I need to do this in a VBA Macro. I hope this is enough information..... |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Detecting particular BG Color in one cell and duplicate it in anot
Try
Different workbooks: Workbooks("Workbook Name 2.xls").Worksheets("Sheet Name 2").Range("B2").Interior.ColorIndex = _ Workbooks("Workbook Name 1.xls").Worksheets("Sheet Name 1").Range("A1").Interior.ColorIndex Different worksheets within the same workbook: Worksheets("Sheet Name 2").Range("B2").Interior.ColorIndex = _ Worksheets("Sheet Name 1").Range("A1").Interior.ColorIndex Note that this may not work if either cell has conditional formatting.... HTH, Bernie MS Excel MVP "RidgeView" wrote in message ... Excel 2007....I have two worksheets where I need to detect a particular cell background color in one of the worksheets and duplicate in another (not the same formated sheet). I need to do this in a VBA Macro. I hope this is enough information..... |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Detecting particular BG Color in one cell and duplicate it in
Thank You very much....your solution worked great!!!!
"Bernie Deitrick" wrote: Try Different workbooks: Workbooks("Workbook Name 2.xls").Worksheets("Sheet Name 2").Range("B2").Interior.ColorIndex = _ Workbooks("Workbook Name 1.xls").Worksheets("Sheet Name 1").Range("A1").Interior.ColorIndex Different worksheets within the same workbook: Worksheets("Sheet Name 2").Range("B2").Interior.ColorIndex = _ Worksheets("Sheet Name 1").Range("A1").Interior.ColorIndex Note that this may not work if either cell has conditional formatting.... HTH, Bernie MS Excel MVP "RidgeView" wrote in message ... Excel 2007....I have two worksheets where I need to detect a particular cell background color in one of the worksheets and duplicate in another (not the same formated sheet). I need to do this in a VBA Macro. I hope this is enough information..... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Detecting Duplicate Sums - Worksheet code | Excel Discussion (Misc queries) | |||
| detecting duplicate input in a cell | Excel Worksheet Functions | |||
| detecting duplicate input in a cell | Excel Worksheet Functions | |||
| detecting duplicate input in a cell | Excel Worksheet Functions | |||
| Detecting cell fill color | Excel Discussion (Misc queries) | |||
Linear Mode
