Simple Question
i want to get rid of the #NUM from my cells. Can i use conditional formatting? and what is the formula to use? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=475271 |
Use IF(ISERROR(Formula),"",Formula) If you have multiple entries you could use a macro also. -- malik641 ------------------------------------------------------------------------ malik641's Profile: http://www.excelforum.com/member.php...o&userid=24190 View this thread: http://www.excelforum.com/showthread...hreadid=475271 |
Hi!
To use cf: Select the cell Conditional Formatting Formula is: =ISERROR(cell_reference) Set the font color to be the same as the background color Another way: Instead of using cf put an error trap in the formula that is returning the #NUM! error. =IF(ISERROR(your_formula)),"",your_formula)) Biff "cjjoo" wrote in message ... i want to get rid of the #NUM from my cells. Can i use conditional formatting? and what is the formula to use? -- cjjoo ------------------------------------------------------------------------ cjjoo's Profile: http://www.excelforum.com/member.php...o&userid=26916 View this thread: http://www.excelforum.com/showthread...hreadid=475271 |
All times are GMT +1. The time now is 12:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com