Jay,

Looks like you are attempting a running total. Here is a code that I have
used in the past to eliminate this. It does not require the use of
conditional formatting. Basically, it checks to see if D2 is blank or if
there is an error summing E1+D2, which it will then return a blank, if not
return the sum E1 + D2.

=IF(OR(D2="",ISERROR(E1+D2)),"",E1+D2)

--
--Thomas [PBD]
Working hard to make working easy.
Answered your question? Click ''''Yes'''' below.


"Jay Fincannon" wrote:

i have a column with formula in cell E2, =$e1+$d2 and copied down 14
rows.
cell E2 is conditionally formatted 'cell value is equal to $e1
format font color white' and the other 14 cells formatted the same.
works ok on the screen but print preview and print on paper prints all
of the values in column E whether the value is the same or different
from the cell above. how come? is there a fix?