Doesn't seem to work, unfortunately. It's doing what my attempts did - colors all the cells. Here's the full code including your piece.
To try, in column A enter in cells:
A1 = Order Date
A2 = 9/1/2016
A3 = 10/1/2016
A4 = 11/1/2016
Ideally, when the code runs, it should conditional format just cell A3 (since it's the last month) in 49407 (and it does, if you edit out the test code), then in the test area for those conditionally formatted cells remove the coloring and just fill it with normal red.
But like I said it does all cells
Bookmarks