vlookup cell format

Hi Expert,

I have a Master sheet which needs to refer a source sheet having the same criteria name and vlookup the status value with the cell format.

Appreciate if someone can help me to code this. I am unable to color code the cell as per the source file.

Please refer the attached file. cell format.xls

Many thanks.
Regards,

Re: vlookup cell format

Hello Expert,

Any help on the above wil be much appreciated.

Thanks.