VBA Color cell in workbook based on value in other workbook

RahulPai123 Posts 2 Registration date Monday February 29, 2016 Status Member Last seen March 1, 2016 - Mar 1, 2016 at 02:45 AM
Hello everyone

I needed a little help with a VBA macro. I have multiple sheets with data and I was wondering if a Macro could be written to pick up values from one excel file and colour the cell in another file based on the value of the first excel. I would greatly appreciate any assistance that I can receive for the above request.

Thanks in advance!!