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
Bookmarks