How can conditional formatting in one cell be copied / applied to many other rows?
M Michelle Dec 5, 2005 #1 How can conditional formatting in one cell be copied / applied to many other rows?
S Sloth Dec 5, 2005 #2 1. Copy cells with conditional formatting 2. highlight destination cells 3. Edit->Paste Special 4. Select Formats 5. Hit Okay
1. Copy cells with conditional formatting 2. highlight destination cells 3. Edit->Paste Special 4. Select Formats 5. Hit Okay