Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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 |
#6
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 |
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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 |
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
copying conditional formats
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? "starguy" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort by conditional formats? | Excel Worksheet Functions | |||
Excel conditional formats | Excel Discussion (Misc queries) | |||
Copying cells with conditional formatting | Excel Discussion (Misc queries) | |||
how do I apply more than 3 conditional formats in excel | Excel Discussion (Misc queries) | |||
copying conditional formatting | Excel Worksheet Functions |