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

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

--


Gary Keramidas
Excel 2003


"Jorge E. Jaramillo" wrote in message
...
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

Excel 2003

ToolsOptionsEdit. Enable "show paste optiions button"

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

In 2007 it would be ButtonExcel OptionsAdvancedCut, Copy and Paste

"Show paste options button"


Gord Dibben MS Excel MVP

On Thu, 28 Jan 2010 18:56:02 -0800, Jorge E. Jaramillo
wrote:

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