Is there a way to change the error "div/0" in data table to "--" using cond. formatting?

Originally Posted by alansidman

combine the Iserror with If statement.

If(iserror(A1),"---",Value if no error)

It is conditional formatting formula, not the formula in a cell. In Data table i cannot add the formula to the cell