reservation workbook

Hi there,

I am looking for some help. I am trying to get the sheet "plot view" to indicate the date's the plot is booked, by changing the color of the cell's. The color will change depending if the plot is booked (blue), a deposit is paid (red) and paid (green), see booking sheet column G. The cell that now changed color can then indicate what is displayed in booking sheet column K.

Please, if someone can point me in the right direction.