Conditional Formatting and week day delays

Hello all,

I am trying to use Excel to calculate if a delay is present in a project, I have attached my spreadsheet.

My idea is as follows:
If the ordered date Column F is less than or equal to Column D then it highlights that cell in Column F green, and Column G green also.

If the ordered date Column F is greater than Column D then it highlights that cell in Column F Red, and Column G red also, with this scenario Column H would be populated with the Working Days delay Column G-C.

Any help is much appreciated on how to achieve this result.

Thanks,

Chris

Thank you Paul, The conditional formatting does not seem to work? I tried that and it always showed Green regardless.

I shall try the H2 equation and update accordingly, thank you again.

Thank you Paul, these worked a treat:
"Try these two:
Green: =DATE(YEAR(F2),MONTH(F2),DAY(F2))<=DATE(YEAR(D2),MONTH(D2),DAY(D2))
Red: =DATE(YEAR(F2),MONTH(F2),DAY(F2))>DATE(YEAR(D2),MONTH(D2),DAY(D2))"

However the Sum for H2 didn't appear to work, I must admit, I thought this was going to be simple, at the moment I stumped though.

For H2 you need the number of business days between Required Delivery Date and Estimated Delivery date, am I correct? If so, this should work:
=IF(YEAR(G2)=1900,"",NETWORKDAYS(C2,G2)) and format it accordingly

Thank you Paul, you are a Star!!!

You solved my dilemma