[SOLVED] Stop #Ref! from showing up

**gogobruno** · 06-02-2010, 02:29 AM

Is there anyway to stop cells telling you when there is a #REF! error?
I just want the cell to be blank until the formula has something to show.

I was thinking in something like a conditional formatting,

=IF(ISERROR cell go blank, if not, act normally, but I need that to the entire sheet.

Thank you!

**Marcol** · 06-02-2010, 03:18 AM

You could try in conditional formatting

Select all the cells then

Formula is =ISERR(A1)

Then format...Font > Colour select white

Obviously this will only work if all your cells with formulae have white backgrounds.

**gogobruno** · 06-02-2010, 03:25 AM

Worked!, thank you!

**Marcol** · 06-02-2010, 03:28 AM

Glad to have been of help to you..

If you need any further information, please feel free to ask further

However

If this takes care of your needs, please click EDIT in your original post, click GO ADVANCED and set the PREFIX box to SOLVED. It helps everybody!
Also
If you are satisfied by any members response to your problem please consider using the scales icon top right of thier post to show your appreciation.