Try selecting the whole column and then add the conditional formatting


VBA Noob