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 varTemp As Variant
varTemp = Worksheets("Summary").Range("F15:F21").Formula
Worksheets("People").Range("G3:G9").Copy
Worksheets("Summary").Range("F15:F21").PasteSpecial xlPasteAllMergingConditionalFormats
Worksheets("Summary").Range("F15:F21").Formula = varTemp
when I run the VB it just select the target cells and ask me to PASTE the results. So the bottom left status bar in 
برچسب:
نویسنده: استخدام کار