Posts by lazer

Re: Copy background color from one cell to cell in separate sheet using ms-excel?

Quote from royUK;773075

Please use Code tags in future.

Also instead of spending time uploading a video attach an example workbook

Try this

Code

'
    Worksheets("sheetA").Range("A1").Copy
    Worksheets("sheetB").Range("A1").PasteSpecial Paste:=xlPasteFormulas, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False
    Worksheets("sheetB").Range("A1").PasteSpecial Paste:=xlPasteFormats, Operation:=xlNone, _
        SkipBlanks:=False, Transpose:=False

Display More

Nice idea please see attachment; there is error in running the code.forum.ozgrid.com/index.php?attachment/69520/

I want to copy background color for example sheetA cell A1 to
sheet B A1.

The cell A1 is using conditional formatting, I can copy simple but not with conditional formatting enabled.

Here is the code

Dim strTemp As String




strTemp = Worksheets("sheetB").Range("A1").Formula
Worksheets("sheetA").Range("A1").Copy
Worksheets("sheetB").Range("A1").PasteSpecial xlPasteAllMergingConditionalFormats
Worksheets("sheetB").Range("A1").Formula = strTemp

The issue , is that my target cells are not populated correctly, see gif animation Link here

https://giphy.com/gifs/l41YBpcLxaGLQYqn6