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