Is there a way to use VBA to copy Conditional Formatting,

(better using =, rather than using the .Copy and .PasteSpecial method)?

Thanks.