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?