Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
One way:

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

=A1/B1

then use

=IF(B1=0,"",A1/B1)
 
You can use CF to change the font to match the background color using

Format>CF>Formula 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
 
Back
Top