Delete CF fill color, replace with regular fill color. Short code, can't figure it out!

Please Login or Register  to view this content.

That's the snippet of my code I'm working on (excluded the rest). It obviously doesn't include a line to fill the cell with a red color, so that would need to be added. Basically, I can't figure out how to go through each cell in the range r12, check if the conditional formatting color is 49407, and if it is then delete the formatting out of the cell and fill it with red.

Originally Posted by protonLeah

Please Login or Register  to view this content.

Thanks, and how do I fill the color if "red" the statement is true but only for those cells? I've tried it before and it fills the entire range rather than the few cells where the CF applied (aka it was filled 49407).

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.

Please Login or Register  to view this content.

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