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? |
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 |