Copy data from one sheet to another based on a certain criteria

[shina67]

Hi,
Hope someone can help. I have a excel sheet sent to me on a daily basis, this sheet changes daily. I alter this sheet over the course of the working day. I have upload the sheet to the following link https://www.dropbox.com/s/zrmcxnbey5...rder.xlsx?dl=0. The following sheet is what it looks like after I have altered things https://www.dropbox.com/s/risd3d4bbh...%201.xlsx?dl=0. If the numbers in column F & G on sheet "Book 1" can be found in columns F & G in "Doorsets Open Order" then I need the colour coding copied from "Book 1" to "Doorsets Open Order". The numbers in column F & G will eventually disappear as the order is shipped out to my customer. Basically the sheet "Doorset Open Order" is a sheet with all my outstanding customer orders and sheet "Book 1" is what I save to let myself know where we are as a department with the order.
Hope someone can help as this will save me hours of work everyday transferring data from "Book 1" to "Doorsets Open Order".
Hope I have enplained correctly what I require.

Regards
Sean