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