suppressing error message
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 |
suppressing error message
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 |
All times are GMT +1. The time now is 02:24 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com