I am wanting to use conditional formating on several hundred rows. I am working in Excel 2010. In the old version I was able to drag the formulas and formating but I can't seem to do this even when I remove the $. I've tried dragging and cut paste special.

This is what I get when I use cut paste special.

B5<>U5
B6<>$U$6:$U$240
B6<>$U$6:$U$240
B6<>$U$6:$U$240


Do I have to go into every individual cell to do a conditional format??