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