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...
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