Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Error
I am having difficulty making cf work in Excel 2007 with XP for an OS. I can
open and use files created in 2003 but some of the cf is corrupted because people have inserted additional rows and copied the cf which is formatted using absolute values. I clear all cf on the worksheet because a lot of the cf is pointing to the incorrect cell. When I enter the cf using the correct location as absolute value or direct cell address, the cf is not performing as expected. I am stating the following: =($E$18=0) if E18 equals zero, then format adjacent cells equal to spaces(they are listed in formatting). This is repeated row after row where 18 is increased until I reach about 150 rows of data. This process worked fine in Excel 2003 and it works ok in Excel 2008 until I try to resolve the corrupted cf. For some reason, it is not returning blank cells in those selected when the formula cell = 0. Usually the value is reported as 0.00. Can someone please point me in the right direction? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Error
If you want it to work on different rows, then you may need to drop
the $ symbol in front of the 18, i.e.: =($E18=0) Hope this helps. Pete On Aug 24, 11:14*pm, marwildfw wrote: I am having difficulty making cf work in Excel 2007 with XP for an OS. *I can open and use files created in 2003 but some of the cf is corrupted because people have inserted additional rows and copied the cf which is formatted using absolute values. I clear all cf on the worksheet because a lot of the cf is pointing to the incorrect cell. *When I enter the cf using the correct location as absolute value or direct cell address, the cf is not performing as expected. * I am stating the following: =($E$18=0) if E18 equals zero, then format adjacent cells equal to spaces(they are listed in formatting). *This is repeated row after row where 18 is increased until I reach about 150 rows of data. This process worked fine in Excel 2003 and it works ok in Excel 2008 until I try to resolve the corrupted cf. *For some reason, it is not returning blank cells in those selected when the formula cell = 0. *Usually the value is reported as 0.00. Can someone please point me in the right direction? * |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Error
The problem is ocurring on the same row. I want the cf to return blanks and
it is leaving the zeroes visible. It appears that the cf is not working at all, whether there are $ signs or not. I am only referencing data on the same row, not multiple rows. "Pete_UK" wrote: If you want it to work on different rows, then you may need to drop the $ symbol in front of the 18, i.e.: =($E18=0) Hope this helps. Pete On Aug 24, 11:14 pm, marwildfw wrote: I am having difficulty making cf work in Excel 2007 with XP for an OS. I can open and use files created in 2003 but some of the cf is corrupted because people have inserted additional rows and copied the cf which is formatted using absolute values. I clear all cf on the worksheet because a lot of the cf is pointing to the incorrect cell. When I enter the cf using the correct location as absolute value or direct cell address, the cf is not performing as expected. I am stating the following: =($E$18=0) if E18 equals zero, then format adjacent cells equal to spaces(they are listed in formatting). This is repeated row after row where 18 is increased until I reach about 150 rows of data. This process worked fine in Excel 2003 and it works ok in Excel 2008 until I try to resolve the corrupted cf. For some reason, it is not returning blank cells in those selected when the formula cell = 0. Usually the value is reported as 0.00. Can someone please point me in the right direction? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional Formatting Error
I cannot get cf to work!
Working on a single row, if E18=0, I want the adjacent cells to appear blank (even though they may have text or numbers in them). This worked in 2003 but will not work in 2007 =$E$18=0 and then I selected the cells to appear blank. I cannot make this work in 2007. Why? It acts like cf is turned off. "marwildfw" wrote: The problem is ocurring on the same row. I want the cf to return blanks and it is leaving the zeroes visible. It appears that the cf is not working at all, whether there are $ signs or not. I am only referencing data on the same row, not multiple rows. "Pete_UK" wrote: If you want it to work on different rows, then you may need to drop the $ symbol in front of the 18, i.e.: =($E18=0) Hope this helps. Pete On Aug 24, 11:14 pm, marwildfw wrote: I am having difficulty making cf work in Excel 2007 with XP for an OS. I can open and use files created in 2003 but some of the cf is corrupted because people have inserted additional rows and copied the cf which is formatted using absolute values. I clear all cf on the worksheet because a lot of the cf is pointing to the incorrect cell. When I enter the cf using the correct location as absolute value or direct cell address, the cf is not performing as expected. I am stating the following: =($E$18=0) if E18 equals zero, then format adjacent cells equal to spaces(they are listed in formatting). This is repeated row after row where 18 is increased until I reach about 150 rows of data. This process worked fine in Excel 2003 and it works ok in Excel 2008 until I try to resolve the corrupted cf. For some reason, it is not returning blank cells in those selected when the formula cell = 0. Usually the value is reported as 0.00. Can someone please point me in the right direction? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
error with conditional formatting | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Discussion (Misc queries) | |||
Conditional formatting error | Excel Discussion (Misc queries) | |||
Conditional Formatting error | Excel Discussion (Misc queries) | |||
Conditional Formatting Error | Excel Worksheet Functions |