Use an IF function
=IF(B1=0,"",A1/B1)
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Traceyb" wrote in message
...
When i follow the conditional formatting instructions it doesnt remove the
#div/0! message that appears in the cells.

Possibly this is because the worksheet has already been created so I am
not
entering this formula for each cell ... is there any quick way to do this
to
the whole worksheet?