Hello, I would be grateful for some help with the following scenario in which the conditional formatting will be in column Q:
If cell S4 is blank then take the date in cell Q4 and subtract it from TODAY making sure that the equation takes into account weekdays and HOLIDAYS (there is a worksheet for the holidays).
If the result is 5 days or greater and 10 days or less then format in yellow.
If the result is 11 days or greater then format in red.
Column Q is the "Date Received" and column S is the "Date Completed"
If column S contains "N/A" then no formatting - not sure if this needs to be considered.
Thank you
Bookmarks