i think you first enter this formula for a single cell then you copy the
format down.
you should first select the range of column where you want to apply
this formula then enter formula in conditional formatting. however it
works fine even entering in single cell then coping downward. I have
applied it in single cell then copied format in below cells it updated
the referred cells automatically.

Steiner Wrote:
=countif(A:A,A2)1

"starguy" wrote:


put your formula here.

Steiner Wrote:
I do not have $ in my "formula is" and it still does not copy
properly.

"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




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