View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Igorin Igorin is offline
external usenet poster
 
Posts: 41
Default 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