First, you are replying to a question that is a 1.5 months old. I doubt OP is still looking for an answer. ;-)
Second, you can select the entire Column B and applying the CF in one step. No need to use the format painter. Just enter the rule for the first cell and it will be applied to every selected cell.
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.