Hi

Make sure that your 'Formula Is' contains relative rather than absolute
references - ie, does not have any dollar signs.

Hope this helps.
Andy.

"Steiner" wrote in message
...
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.