I have done a lot of searching on here but haven't found any exact answers to my problem. I have a lot of variable data ranges in my workbook with several tabs, 2-3 times a day the workbook is wiped clean and new data is imported from SAP. In my "printing" tabs I use conditional formatting and I regularly use remove duplicates. When you use Remove Duplicates with a conditional format, it takes my selection of $N:$N and turns it into $N1:$N50, $N75, $N100, etc. So when I import data again, I have to re-do the range for every Conditional Format to catch everything.

Hopefully I was clear on my explanation, so am I using CF wrong, or can I use VBA to re-apply as I'm importing and removing duplicates. My CF Rule is simple, $N:$N, highlight anything less than 1.