Conditional Formatting for #DIV/0!
Hello,
Does anyone how to do the following? I have several columns that contain a division formula that make reference to other cells. Some cells will not not always contain data. Because of this I'm getting a #DIV/0! error (which is totally normal and to be expected). What I wish to do is to make the #DIV/0! disappear using conditional formatting, for example, 'If "=#DIV/0!" then use font color white'. Any ideas how this can be done? Maybe there is another way to achieve this without using conditional formatting. I'm using Excel 2003. Thanks for the help. -- igor |
Conditional Formatting for #DIV/0!
Try this:
=IF(B1=0,"",A1/B1) |
Conditional Formatting for #DIV/0!
Thank you very much!
-- igor "TomPl" wrote: Try this: =IF(B1=0,"",A1/B1) |
Conditional Formatting for #DIV/0!
try this one too.
=if(iserror(a1/b1),"",a1/b1) "Igorin" wrote: Thank you very much! -- igor "TomPl" wrote: Try this: =IF(B1=0,"",A1/B1) |
Conditional Formatting for #DIV/0!
Hi,
The formula solutions are considered better solutions than using conditional formatting, but if you really wanted to use formatting assume that the top left corner of your range, which you select, is A1: 1. Choose Format, Cells, and from the first drop down pick Formula is 2. In the next box enter the formula: =ISERR(A1) 3. Click the Format button and on the Font tab pick the Color White. Click OK twice. So in the spreadsheet, considering the formulas you have already recieved, you could also use =IF(B1,A1/B1,"") -- Thanks, Shane Devenshire "Igorin" wrote: Hello, Does anyone how to do the following? I have several columns that contain a division formula that make reference to other cells. Some cells will not not always contain data. Because of this I'm getting a #DIV/0! error (which is totally normal and to be expected). What I wish to do is to make the #DIV/0! disappear using conditional formatting, for example, 'If "=#DIV/0!" then use font color white'. Any ideas how this can be done? Maybe there is another way to achieve this without using conditional formatting. I'm using Excel 2003. Thanks for the help. -- igor |
Conditional Formatting for #DIV/0!
Thank you, Shane!
-- igor "ShaneDevenshire" wrote: Hi, The formula solutions are considered better solutions than using conditional formatting, but if you really wanted to use formatting assume that the top left corner of your range, which you select, is A1: 1. Choose Format, Cells, and from the first drop down pick Formula is 2. In the next box enter the formula: =ISERR(A1) 3. Click the Format button and on the Font tab pick the Color White. Click OK twice. So in the spreadsheet, considering the formulas you have already recieved, you could also use =IF(B1,A1/B1,"") -- Thanks, Shane Devenshire "Igorin" wrote: Hello, Does anyone how to do the following? I have several columns that contain a division formula that make reference to other cells. Some cells will not not always contain data. Because of this I'm getting a #DIV/0! error (which is totally normal and to be expected). What I wish to do is to make the #DIV/0! disappear using conditional formatting, for example, 'If "=#DIV/0!" then use font color white'. Any ideas how this can be done? Maybe there is another way to achieve this without using conditional formatting. I'm using Excel 2003. Thanks for the help. -- igor |
Conditional Formatting for #DIV/0!
Great! Thanks a lot!
-- igor "dfunk" wrote: try this one too. =if(iserror(a1/b1),"",a1/b1) "Igorin" wrote: Thank you very much! -- igor "TomPl" wrote: Try this: =IF(B1=0,"",A1/B1) |
All times are GMT +1. The time now is 11:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com