Hi,

I use formulas that can come across errors such as divide by zero occasionally, it's just the nature of the data not being available on occasion.

Previously i have used conditional formatting to make the text white if there is an error. This is a very, ermm, dumb, way to do it. But it works. Kinda.

"Kinda" is the issue here. When iIwent to print my smart looking powerpoint presentation that made use of my excel tables, to my horror, the printer decided to ignore that the text was white on white formatting and just print it black, so these usgly errors are visible in my table!

Alright to cut the rant short and get to the point, is there a way to truly ignore these errors, including when transferring the data into powerpoint and when printing? (I assume theres an option when printing to not do this, but still it makes more sense to solve the root of the problem instead.) to either show a blank box, or a 0.

Thanks.