I am trying to to set up a "Formula is" conditional format and when I try to
copy the formula down, the cell location does not automatically adjust. The
same cell location I used in the initial cell copies down to all the others.
Sometimes it works and more often it does not. I am using copy/paste
special/formats.

Also, I am pulling a text file into excel, would this make a difference?

Thank you.