Conditional Formatting Error

[marwildfw]

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?

 

[Pete_UK]

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

 

[marwildfw]

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.

 

[marwildfw]

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.