Conditional formatting
 

I am putting together a spread sheet with many formulas that track employee
performance. Not all formulas have values. Is there a way to Hide the formula
in a cell when there is not data for it to calculate?

Currently what is showing is "#DIV/0!". I would like to be able to print the
spread sheet out at any given time for a presentation and not have to read
arount the display that I am recieving when there is no data to calculate.

thank you

Conditional formatting
 

One way:

If your formula giving you #DIV/0 is of the form

=A1/B1

then use

=IF(B1=0,"",A1/B1)





In article ,
THFish wrote:

I am putting together a spread sheet with many formulas that track employee
performance. Not all formulas have values. Is there a way to Hide the formula
in a cell when there is not data for it to calculate?

Currently what is showing is "#DIV/0!". I would like to be able to print the
spread sheet out at any given time for a presentation and not have to read
arount the display that I am recieving when there is no data to calculate.

thank you

Conditional formatting
 

You can use CF to change the font to match the background color using

FormatCFFormula is: =ISERROR(cellref)

I would prefer to trap the error in cell and leave the cell looking blank until
a number is entered.

=IF(B1="","",A1/B1) would trap for B1 having no value and return nothing.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 12:03:01 -0700, THFish
wrote:

I am putting together a spread sheet with many formulas that track employee
performance. Not all formulas have values. Is there a way to Hide the formula
in a cell when there is not data for it to calculate?

Currently what is showing is "#DIV/0!". I would like to be able to print the
spread sheet out at any given time for a presentation and not have to read
arount the display that I am recieving when there is no data to calculate.

thank you

Conditional formatting
 

Thank you for the suggestion. That took care of my issue.

"Gord Dibben" wrote:

You can use CF to change the font to match the background color using

FormatCFFormula is: =ISERROR(cellref)

I would prefer to trap the error in cell and leave the cell looking blank until
a number is entered.

=IF(B1="","",A1/B1) would trap for B1 having no value and return nothing.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 12:03:01 -0700, THFish
wrote:

I am putting together a spread sheet with many formulas that track employee
performance. Not all formulas have values. Is there a way to Hide the formula
in a cell when there is not data for it to calculate?

Currently what is showing is "#DIV/0!". I would like to be able to print the
spread sheet out at any given time for a presentation and not have to read
arount the display that I am recieving when there is no data to calculate.

thank you