On one sheet I have a data which has conditional formatting color.
I want to copy and paste that into another file, I was able to paste value, column width etc. but I couldn't paste the color from the conditional formatting.
I researched and the suggestion was to paste it in word and then back to excel but that ruins my excel row and column formatting.
How to do that? Is it possible?
Best Answer
I would like to suggest you two possible methods. One is Non-programming & Second is Programming(VBA Macro).
Non-Programming Method:
Programming Method:
At Source File press
Alt+F11
to open the VB Editor.Copy & paste this code as Standard module.
Note: