conditional format cells with formula

A

amos

I have a summary worksheet that references another with a vlookup table. The
conditional formatting works if a value is entered on the lookup sheet.
However, if the cell isn't filled with a number on the summary sheet I get
the #N/A. That is what I'm trying to hide this with text color. PLEASE help?
 
P

PCLIVE

Maybe something like this in your conditional formatting:

=ISERROR(A2)

You also apply this type of statement to your formulas in the cell instead
of using conditional formatting.

HTH,
Paul
 
M

Max

You could try adding Condition 2 with a suitable format to mask the #N/A

Assuming B2 is the top left active cell selected within your conditional
formatting range, Formula is: =ISNA(B2)
Format the font color same as fill color
 
A

amos

IS ERROR didn't work. Not to be a thick-head but I don't quite understand
what you mean in adding this statement to my formula. Can you give an
example please?
 
A

amos

This is exactly what I want to do. However this has been suggested and
doesn't work. I have 2003.
 
M

Mankind

the #N/A. That is what I'm trying to hide this with text color. PLEASE
help?

what kind of hiding u prefer on printing or on the monitor ?

I may not suggest to change your formula in the cell unless these #N/A has
relevance on some other things.<eg linked?>.
 
A

amos

help?

what kind of hiding u prefer on printing or on the monitor ?

I may not suggest to change your formula in the cell unless these #N/A has
relevance on some other things.<eg linked?>.
 
M

Mankind

the #N/A. That is what I'm trying to hide this with text color. PLEASE
help?

what kind of hiding u prefer on printing or on the monitor ?


I may not suggest to change your written formula in the cell unless if these
#N/A has no relevance on some other things on your *summary* sheet.<eg
linked?>.
 
P

Peo Sjoblom

Why don't you hide it in your formula that returns the error instead?

=IF(ISNA(VLOOKUP),"",VLOOKUP)

replace VLOOKUP with your vlookup formula


--


Regards,


Peo Sjoblom
 
M

Max

amos said:
This is exactly what I want to do.
However this has been suggested and
doesn't work. I have 2003.

It works ok here, in my xl2003.

Maybe try switching/escalating the error trap/format to Condition 1?

If it still doesn't work, could you post your condition 1's formula
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top