I
Igorin
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.
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.