Hi,

I have been playing around for a while now with network days, weekdays etc etc but can't seem to get a formula to work in Conditional Formatting.

I need a cell to be highlighted red once the date entered is 3 or more working days less than today. (i.e missed deadline)
In an ideal world, I would like it then to highlight green once a subsequent date is then entered in another cell, to show that the action has been performed.

For example.

Cell B2 contains date. Once this date is 3 working days less than today, it highlights red.
Cell C2 is initially blank, but once cell B2 highlights red, a date should be entered in C2 to confirm action has been performed and therefore, cell B2 should now become green.

Hope this makes sense, I am using Excel 2003

TIA