Good morning Excel Forum,
I need help with conditional formatting, maybe even using offset. Here's my dilemma;
- Trying to figure a way to show a status of over due in column K, using the scheduled date in column G against todays date. If possible having a transitioning color (green to red) would be better great. I am required to ensure our shipments are on time and the previous manager had no way to track these shipments. Also is there a way to number the row and skip the blank rows? There are several more rows in the original file. Thank you in advance for your help!
Rick
Bookmarks