DIV/0

I have 4 cells that are the sum of four columns of data and some other stuff
(that is determined by running a macro). The columns contain the unit
pricing for different suppliers, and the macro applies the unit prices to the
quantities needed and gives the total the cell mentioned above. If the
column of datais empty (i.e. no pricing is available for the supplier) then a
#DIV/0! is returned which is I understand. What I would like to do is either
apply conditional formatting to the cells (say A20 thru D20) which says that
if it is equal to #DIV/0! then the font color is clear so it doesn't show up
or add some code in the macro that looks at each of the 4 cells and if it is
equal to #DIV/0 then it clears the contents.

The cells are NOT formulas, they are just the results of a copy and paste
special values. So I can't simply tell the formula to use "". I am having a
hard time getting the conditional formatting to respond to #DIV/0! but I am
sure there is someone out there who konws how to do it with using the macro
-- I just dont

Any Ideas???

The cf is the easy way out!

Conditional Formatting
Formula is =ISERROR(A1)

I can't help with the macro but someone that can will
surely ask you to post the code for analysis.

Biff

-----Original Message-----
I have 4 cells that are the sum of four columns of data
and some other stuff
(that is determined by running a macro). The columns
contain the unit
pricing for different suppliers, and the macro applies
the unit prices to the
quantities needed and gives the total the cell mentioned
above. If the
column of datais empty (i.e. no pricing is available for
the supplier) then a
#DIV/0! is returned which is I understand. What I would
like to do is either
apply conditional formatting to the cells (say A20 thru
D20) which says that
if it is equal to #DIV/0! then the font color is clear so
it doesn't show up
or add some code in the macro that looks at each of the 4
cells and if it is
equal to #DIV/0 then it clears the contents.

The cells are NOT formulas, they are just the results of
a copy and paste
special values. So I can't simply tell the formula to
use "". I am having a
hard time getting the conditional formatting to respond
to #DIV/0! but I am
sure there is someone out there who konws how to do it
with using the macro
-- I just dont

Any Ideas???
.

Hi
just as a different approach: Why not correct the source formulas to
prevent the #DIV/0 Error?

--
Regards
Frank Kabel
Frankfurt, Germany

"wiredbliss" schrieb im
Newsbeitrag ...
I have 4 cells that are the sum of four columns of data and some
other stuff
(that is determined by running a macro). The columns contain the
unit
pricing for different suppliers, and the macro applies the unit
prices to the
quantities needed and gives the total the cell mentioned above. If
the
column of datais empty (i.e. no pricing is available for the
supplier) then a
#DIV/0! is returned which is I understand. What I would like to do
is either
apply conditional formatting to the cells (say A20 thru D20) which
says that
if it is equal to #DIV/0! then the font color is clear so it doesn't
show up
or add some code in the macro that looks at each of the 4 cells and
if it is
equal to #DIV/0 then it clears the contents.

The cells are NOT formulas, they are just the results of a copy and
paste
special values. So I can't simply tell the formula to use "". I am
having a
hard time getting the conditional formatting to respond to #DIV/0!
but I am
sure there is someone out there who konws how to do it with using the
macro
-- I just dont

Any Ideas???