thanks for the reply chris

That didnt seem to work unfortunately. Let me try and explain it a bit better. The current code pastes from a sheet quote2 to a sheet called vknew. Users select items on quote2 by inserting a '1'. If the cell calue in column D is greater than '1', then column A and D pastes to vknew colums A and F. What i need is, if column C on quote2 where the selctions are made is highlighted red, then the data from column D is to paste to column G instead of column F (vknew). Basically, the cell being red is to provide a point of differentiation for the user and this should reflect on Vknew by showing a figure in an alternate column

Another idea???? Thanks chris!!!!!