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

خرید بک لینک

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 video

Recent Questions...

ما را در سایت Recent Questions دنبال می‌کنید

برچسب: نویسنده: استخدام کار بازدید: 221 تاريخ: يکشنبه 6 تير 1395 ساعت: 14:40

صفحه بندی