Override Conditional Formatting Color

Currently I have used all 3 conditional formats to colour certain cells.

1) Colour whole row 'green' when 'complete' colum ="Y"
2) Colour todays date column black in the date table to easily define todays activities.
3) By entering start and end dates that contractors are required, I colour these selected dates in blue with a letter 'x' in the calendar area.

This can easily be seen from the sample sheet above. If you can adapt this for yourselves carry on.

I am also using a macro (found in these forums) to automatically change the colour of the contractors tab to certain colours when selected from the drop down selection box (enabling more than just 3 conditional formats)

What I would like to happen though, is that when item 3 above is performed (select a start and end date) the filled blocks, colour the same as the contractor colour, instead of the blue with the 'x'.