copying conditional formats

[Guest]

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]

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

 

[Guest]

Hi

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

Hope this helps.
Andy.

 

[Guest]

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

 

[starguy]

put your formula here.

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

 

[Guest]

=countif(A:A,A2)>1

put your formula here.

 

[starguy]

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

=countif(A:A,A2)>1

 

[Guest]

I am still not able to get this function to work. I have tried opening a new
worksheet and randomly adding numbers (some that duplicate) and it still will
not work. I am using excel 2003. Is there an add-on I may be missing?