Sorry my bad.

I actually need to update the question.

I need to loop through all used cells that has backgroundcolor xlNone and change the cells to interior.colorindex=2