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