Paste conditional formats

Brass Contributor

I am having a master file (Complex & large) hence I want to avoid conditional formats in the master file. Instead another sheet for performing all my conditional formats and paste conditional formats to the master sheet at the end of the day.  Ok even if the conditional formats is part of master excel file.

 

Any help please

1 Reply
Either you can try creating a duplicate sheet (Let say Sheet12) of the master file (Sheet 1) & made the changes on the Duplicate (Sheet12) and hen paste the format to the Original Sheet (Sheet 1).

You can also try using vba, if you want.