Select entire sheet (with A1 active), and apply the CF as
Condition 1: =ISERROR(A1)
Format the font color white (to mask)
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"_Bigred" wrote:
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