copying conditional formatting to different sheet

lezawang

Well-known Member
Joined
Mar 27, 2016
Messages
1,559
Hi
I have no problem to copy conditional formatting from one cells to another in the same sheet using format painter tool. But I noticed I can not copy conditional formatting to different sheet? Is that by design? Thank you
 

Some videos you may like

Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.

mole999

Moderator
Joined
Oct 23, 2004
Messages
10,299
Office Version
2019, 2016, 2013
Platform
Windows
try paste > values the paste > format. I've not seen a way to do it first time
 

Watch MrExcel Video

Forum statistics

Threads
1,095,794
Messages
5,446,529
Members
405,406
Latest member
tuxy

This Week's Hot Topics

Top