Hi
do you really get #NUM errors I would expect a #NA error. So you may
post your existing formula. But as a general idea:
1. use a formula
=IF(ISERROR(your_formula),"",your_formula)

2. within conditional format use the formula
=ISERROR(cell_reference)
and use a white font

--
Regards
Frank Kabel
Frankfurt, Germany

"colm o'brien" schrieb im
Newsbeitrag ...
I have a sheet which uses match to reference another sheet in look up
it works ok but when the item is not there i get the error message
#NUM!
this is fine but i wanted to hide this message but not when a match
is found

i tried conditional formatting to colour white text when cell value
is #Num! but this hasn't worked

any ideas


colm

Fran
I stand correccted it is a #NA erro

option 2 below is the way to g

thank



----- Frank Kabel wrote: ----

H
do you really get #NUM errors I would expect a #NA error. So you ma
post your existing formula. But as a general idea
1. use a formul
=IF(ISERROR(your_formula),"",your_formula

2. within conditional format use the formul
=ISERROR(cell_reference
and use a white fon

-
Regard
Frank Kabe
Frankfurt, German

"colm o'brien" schrieb i
Newsbeitrag ..
I have a sheet which uses match to reference another sheet in look u
it works ok but when the item is not there i get the error messag
#NUM
this is fine but i wanted to hide this message but not when a matc
is foun
i tried conditional formatting to colour white text when cell valu
is #Num! but this hasn't worke
any idea
col