Re: Hiding error formulas in spreadsheet
- From: "CyberTaz" <typegeneraltaz1ATcomcastdotnet>
- Date: Thu, 28 May 2009 09:04:06 -0400
A couple of other options:
Use the formula: =IF(ISERROR(cellref),"No Data",cellref) Of course you can
substitute anything you prefer between the quotes as the Value_If_True or
just use "".
Use Conditional Formatting: Choose "Formula Is:" from the dropdown then
enter the formula =ISERROR(cellref) & choose white as the Font color.
NOTE: [cellref is the cell you're putting the IF() function in or applying
the Conditional Formatting to]
--
HTH |:>)
Bob Jones
[MVP] Office:Mac
<Crofton@xxxxxxxxxxxxxxxx> wrote in message
news:59b756eb.-1@xxxxxxxxxxxxxxxxxxxxxxxxxx
Version: 2008
Can you please help
I am trying to hide error messages that show within a spreadsheet.
Currently when I 'drag' a formula to complete the rest of the columns for
automatic infilling it displays the hash sign plus DIV/0!.
The formula is right and doing what it should do but is there a way I can
'turn off' the error display in the cell so it is blank until populated.
Many thanks
.
- Follow-Ups:
- Re: Hiding error formulas in spreadsheet
- From: CyberTaz
- Re: Hiding error formulas in spreadsheet
- References:
- Hiding error formulas in spreadsheet
- From: Crofton
- Hiding error formulas in spreadsheet
- Prev by Date: Re: Hiding error formulas in spreadsheet
- Next by Date: Re: Page Size Reverts to Letter when Set for Tabloid
- Previous by thread: Re: Hiding error formulas in spreadsheet
- Next by thread: Re: Hiding error formulas in spreadsheet
- Index(es):
Relevant Pages
|
