Conditional formatting

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

THFish - 09 Oct 2007 20:03 GMT

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

Reply to this Message

JE McGimpsey - 09 Oct 2007 21:01 GMT

One way:

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

=A1/B1

then use

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

> 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
[quoted text clipped - 5 lines]
>
> thank you

Reply to this Message

Gord Dibben - 09 Oct 2007 21:22 GMT

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

>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
[quoted text clipped - 5 lines]
>
>thank you

Reply to this Message

THFish - 09 Oct 2007 21:41 GMT

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

> You can use CF to change the font to match the background color using
>
[quoted text clipped - 16 lines]
> >
> >thank you

Reply to this Message

Rate this thread: