VBA Code:
' VBA Code to Copy Conditional Formatting to Another Range in Excel
' This code copies conditional formatting from one range to another
Sub CopyConditionalFormatting()
Dim rngSource As Range
Dim rngTarget As Range
' Set the source range with conditional formatting
Set rngSource = Range("A1:A10")
' Set the target range where conditional formatting should be copied
Set rngTarget = Range("B1:B10")
' Clear existing conditional formatting in the target range
rngTarget.FormatConditions.Delete
' Copy conditional formatting from source range to target range
rngSource.Copy
rngTarget.PasteSpecial Paste:=xlPasteFormats
' Clear the clipboard
Application.CutCopyMode = False
' Optional: Display a message box when the conditional formatting is copied
MsgBox "Conditional formatting has been copied to the target range."
End Sub
Join Our Telegram Group
Join Our WhatsApp Group
