hide #DIV/0 errors with conditional formatting

I'm not sure exactly how the dialogs are arranged in 2013. In 2007 I can select Home -> Conditional formatting -> New rule -> Format only cells that contain -> Cells with -> Errors -> Set format rule -> Font color same as background color (white on white in my case).

Like the IFERROR() function, that will apply to all errors, not just Div/0 errors. If you are satisfied with a solution that hides all errors, then that should work.

If you want to hide only Div/0 errors and allow the other errors to be visible, then use a formula as your conditional format rule, and use the ERROR.TYPE() function https://support.office.com/en-us/art...rs=en-US&ad=US

The DIV/0's participate in a greater sum formula, so I need replace them with ""

Would "wrapping" the references or calculations that return DIV/0's in the ISNUMBER function help that part of the problem? Summing 0s would return the same as summing the ""s. Then MrShorty's solution could still work.

Conditional formatting does not change the underlying value of a cell. If a cell formula results in an error, then that is the cell's value, and most if not all of excel's functions, if they refer to a cell with an error, will propagate that error. Formatting will not change that.

If the errors are causing a problem in downstream calculations, then you need to use some kind of error trapping to cause the function to return something other than the error. Standard 1st answer is to use the IFERROR() function like you initially described. If you want errors to be treated as 0 in another sum, then something like =IFERROR(current formula,0) (or "" or other text when using the downstream function is a SUM() function that ignores text. Of course, there are other options, depending on exactly how you want to trap the error. Since you already seem familiar with at least the IFERROR() function, I will assume you can do the error trapping you need. Conditional formatting or other formatting options are not going to do this kind of error trapping.

I don't think any of us has suggested that there is no way to do this, we just don't have enough context to understand exactly what you need done here.

If your current formula is easily copied, it might be as easy as editing the first instance of the formula to wrap the IFERROR() around the current formula, then copy and paste into the other instances of that formula.

You indicated that these errors are interfering with another SUM() function. Something like =SUM(IFERROR(A4:A44,0)) entered as an array function (ctrl-shift-enter) will trap the errors inside of the sum function and replace them with 0's before performing the sum.

If you can provide more details about the changes that need to be made (perhaps upload a copy of your current spreadsheet with dummy data, if needed), then we will be able to see how the error and error trapping fits into the overall spreadsheet and make better recommendations from there.