Error Messages

[Jo Davis]

Hi

Is there a way in my settings that i can get Excel to hide formula error
messages?

any help would be most appreciated.

Cheers
Jo

[tony h]

You have various option for handling errors.

Assuming that you are talking about worksheet functions returning error values, rather than VBA code there are two options.

1. correct the result using something like =if(iserror(formula),"",formula) this leaves the cell clear if the formula returns an error.

2. cosmetically only you can use the conditional formatting (again using the =iserror(A1) ) to set the font colour the same as the background colour.

Just think carefully about future maintenance.