One way:

Conditional Formatting | Formula is: =ISERROR(cell)

=ISERROR(L21) (for example)

Format the font to be white (or the same as the background colour in the
cell)

Regards

Trevor


"_Bigred" wrote in message
...
I have a sheet that has approx 7,000 rows.

Until I get all the data into it many columns will contain: #DIV/0! or
#VALUE!

I would like to do some conditional formatting to hide this error values,
does anyone know how I can do it?

TIA,
_Bigred