Interior ColorIndex on Excel Macros

Interior ColorIndex on Excel Macros

Hi,

I'm facing a problem right now. Actually i'm writing some codes on macros to assist in data migration. The whole thing work like this.. the data will be changed accordingly with the lookup list.. so how can i do to shade the cells that have changed to the values according to the lookup list. Pls help... :D