Cell A1 has a formula that provides a #N/A error, in the same way that the
desired cells produce an #N/A error:
The cells that need to be white are coded =VLOOKUP(B4,SHEET1,10) where B4 is
='SHEET2'!C4. C4 is blank, so B4 returns 0. The result is #N/A. (When C4 is
no longer blank, B4 displays data and needs to be visible.)
This is the only conditional format used in the spreadsheet. I've tried to
find out if anyone else has this problem and had no luck.
Your problem is that you are using an absolute cell reference, change
the formula to =ISERROR(A1)
Notice the $ signs has been removed to indicate that it is a relative
reference.
Regards,
Per
I would use ISNA which is specific to your needs.
Your formula has absolute reference to $A$1
Each cell in the range looks only at $A$1 for the condtion.
Remove the $ signs.
=ISNA(A1)
Gord Dibben MS Excel MVP
On Wed, 6 Jan 2010 16:04:01 -0800, SMW <S...@discussions.microsoft.com>
wrote:
"Per Jessen" wrote:
> .
>
"Per Jessen" wrote:
> .
>
(I'm using "Formula is" rather than "Cell Value is.")
"Gord Dibben" wrote:
> .
>
By the way, I presume that changing the text to white makes it disappear. If
that's what you want, you're better off using formulas like:
=if(isna(yourformula),"",yourformula)
Regards
Fred
"SMW" <S...@discussions.microsoft.com> wrote in message
news:4B304650-83A7-4875...@microsoft.com...
Regards,
Fred
"SMW" <S...@discussions.microsoft.com> wrote in message
news:B02369E6-93CA-456F...@microsoft.com...
"Fred Smith" wrote:
> .
>
HOWEVER I tried the IF(ISNA) formula and it holds up under testing, making
the text disappear when the formula produces an error!! Thanks a million :)
"Fred Smith" wrote:
> .
>