Retaining Conditionally formated interior.colorindex

[zaska]

Hello,

I have used conditional formating for filling cells with a single color depending on the values in column A. Now, is there any way to retain the conditionally formatted interior.color index if Column a is deleted ?

Regards,
Zaska

 

[drsarao]

Retain in new col A which was col B before? No!
Use format painter to copy formats from A to B before delete. (Format painter copies the Conditional formats too.)