Posted to microsoft.public.excel.worksheet.functions
|
|
copying conditional formats
=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
|