So....I have a formula in A5 and the cell meets CF and is white (which is good) and that is copied over by the macro. But when the formula is deleted out of the column that is copied and pasted it doesnot change to the 'base' (yellow) color of the copied cell. I guees Im correct in saying that I can't have the CF and the base color as well? Maybe mamma was right when she said I cant have my cake and eat it too?
Thanks!!!!