How to find #DIV/0!

[jfalesi]

Hello. I found lots of info about avoiding divide-by-zero errors, but I can't find any info on how to FIND div-by-zero. I have several large spreadsheets that were sent to my by another person, and I would like to audit them. I need an easy way to indicate the cells with div-by-zero errors. I can't figure out how to do it with Excel's Find find function, and the "Indicate errors using this color" option in the Formulas tab of Excel Options doesn't seem to work... the cells are still black text on white background. Ideally, I'd like to change the error cells to red with white text.

Thanks,
-Jamie

 

[Roderick_E]

For conditional:

=ERROR.TYPE(D1)=2

 

[jfalesi]

Thanks, but I found a solution - conditional formatting on cells with errors.