VBA Color cell in workbook based on value in other workbook

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!!
Cheers!!