Hi Guys, i have tried quite a bit with this still no joy, rb your suggestion simply saw the condition "If MyOp = 3" as true for each MyCell in range (as the conditional formatting would turn the cell red if the condition is satisfied) so it transferred all of the points, i think i'm getting VBA blind now as i can't seem to get past this very simple (or it started out that way) task!

Any further ideas?