conditional formating

[Miri]

how do i copy conditional formating from one cell to other(in code)?
another question: how do i copy cell (or cells) without conditional
formating but with all others(formula, formats, values) (in code)

 

[Bob Phillips]

Range("A1").Copy
Range("B1").PasteSpecial Paste:=xlPasteFormats

and

Range("A1").Copy Range("B1")
Range("B1").FormatConditions(1).Delete


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)