I am trying to format a template to highlight when dates are approaching. I am trying to get the conditional formatting to work for highlighting light red when a due date is within the next month, within the next week the cell becomes a shade darker red, and then is bright red when it is past due. I need to put a second condition in though. The attached file has a column for when a submittal is due. That is the main driver. However, I need to set it up so that when the column following it, Submittal Received, is filled in, it no longer highlights based on the due date.
Basically, I want to highlight approaching due dates with escalating shades of red as the date nears but once the item has been received, I no longer need the cells to be highlighted.
Any help would be greatly appreciated. Thank you!
Bookmarks