Conditional Formatting a cell based on a) its colour b) the value of a different cell

Hello,

I have set up a tracking document that captures the start and end date of a project, and generates a green bar in the cells to the right hand side- these represent a calender

The values I enter in the green cells represent the amount of employees I need per day, and as such row 3 captures the total amount of employees I need on any given day.

At the moment I am inputting the employee values in to the green cells manually. In an ideal would I would like to enter the employee requirement in column C, and have the spreadsheet input the value in the green cells of that row for me.

Many thanks to anyone who may be able to give me some guidance.

I have attached a spreadsheet for visual aid.

Thanks,
Luke