Forum Discussion

Vinod2406's avatar
Vinod2406
Brass Contributor
Nov 02, 2023

Paste conditional formats

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

Excel
Macros and VBA
office 365
  • Excelonlineadvisor's avatar
    Excelonlineadvisor
    Iron Contributor
    Nov 02, 2023
    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.

Resources