Hey Chandoo, not sure if you have posted a trick on this. My problem is; I have a list of data (mix of text and numbers) from a1 to a100. say I highlighted in yellow, cells a2,a34,a48...and so on..depending what i want to select from the list. next day i get a updated list from an email. What i want to achieve is l want to transfer the same highlighting to the updated list. That is on the new list, data from previous list on cell a2,a34,a48 that was previously highlighted, needs to be also highlighted on this new list. However anything not highlighted earlier should stay the same. is it possible to do that?