Can the format of the destination cell be kept?

[Jorge E. Jaramillo]

I keep track of the "state" of customers depending on different criteria and
for that I have conditional format to change the color of the cells.

Once a cycle ends, I need to keep record of the last state in another colum
so that the new cycle can begin. The problem is that when I copy the old
content into the new cell, it brings along its color and I need it to be
plain white. I know that I could choose paste special and then just choose
value and that would bring just the value without the color, but I want to
copy the old contents in a shorter way. So is there a way that no matter what
color a source cell has, the text in the destination cell will be just plain
old black over a white background?

Thanks

Jorge E Jaramillo

 

[Gary Keramidas]

did you try just selecting paste values? right click copy the cell. right click the
destination, choose pastespecial then then select values or formulas

 

[Gord Dibben]

Excel 2003

Tools>Options>Edit. Enable "show paste optiions button"

After pasting, click on the dropdown and "match destination formatting"

In 2007 it would be Button>Excel Options>Advanced>Cut, Copy and Paste

"Show paste options button"


Gord Dibben MS Excel MVP