remove $ from your formula in conditional formating then copy formats.


Steiner Wrote:
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.


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=568978