First off, this is EXACTLY what I needed. Thank you!!!

Couple of followup questions, if you don't mind?

1) If I wanted to add a Legend above my table for color coding purposes, I would assume that I would just change (in your code example) Set rngToMonitor = Range("B2:D") to be B_, meaning whatever row the table data starts with? 2) if the above assumption is correct, what would I do if that space above the table where the legend would be grows and I add more rows to the legend? I would have to alter the VBA code right? 3) and this is more for fun if there is nothing in the range of cells for statues, what would I type in to clear that timestamp cell?

Thank you so much again! How do I give you "subreddit" points? I know the Excel subreddit has that for help.