lisamarie1771
New Member
- Joined
- Feb 9, 2014
- Messages
- 8
I have a spreadsheet with four columns.
A = Scheduled Pack Date
B = Submission Date (must be 8 days or greater than A)
C = Release Date (must be 3 days or greater than A)
D = Company holidays
I want to set conditionally formatting that determines if B & C are false, after excluding weekends and holidays, then turn the cell red, if true turn green
I only now to turn it red or green without the exclusion of weekends and holidays. I thought using networkdays, but I still can't do it.
Any help would be greatly appreciated.
A = Scheduled Pack Date
B = Submission Date (must be 8 days or greater than A)
C = Release Date (must be 3 days or greater than A)
D = Company holidays
I want to set conditionally formatting that determines if B & C are false, after excluding weekends and holidays, then turn the cell red, if true turn green
I only now to turn it red or green without the exclusion of weekends and holidays. I thought using networkdays, but I still can't do it.
Any help would be greatly appreciated.