Prevent Changes to Conditionally Formatted Cells

Well, I figured out a workaround to this. Cut the column D and paste into a different sheet in the workbook. The conditional formatted values will follow that column to its new home. I can create a new Quantity column with the updated quantities, apply the conditional formatting rules to a cell in that new column, use the format painter and done. All new entries (counts) will format as desired and there will be no changes made to the previous quantities. Hopes this helps someone else. If someone shares a better solution to this, that would be great.