I'm sorry if this is answered in another thread, I tried searching but didn't find anything like what I was trying to do. I have a report that tracks an order through production processes. The order will go through many different processes before reaching completion, but all orders do not go through all of the same processes. What I'm trying to do is highlight all cells between the order entry date and the last cell in that row that has a filled in cell, that way visually it would show how far the order has progressed. I attached an example of what I am trying to accomplish. I would like to be able to do this automatically, but am unsure of how to accomplish that. I can create a conditional format that highlights all cells that have data, but obviously that leaves the ones in between blank. Thank you for any help you can give, and I apologize again if this is a stupid question or has been answered somewhere else.
Bookmarks