Hide Errors

Right click the range and select Format Cells, Number, Custom

Use this format

[Black]General

Then change the font color to the same color as your cell background (usually white)

It will show regular entries but hide errors.



© Copyright andrewsexceltips.net. All Rights Reserved.