conditional format cells with formula

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

Guest

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?
 
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
 
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
 
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?
 
This is exactly what I want to do. However this has been suggested and
doesn't work. I have 2003.
 
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?>.
 
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?>.
Click to expand...
 
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?>.
 
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
 
amos said:
This is exactly what I want to do.
However this has been suggested and
doesn't work. I have 2003.
Click to expand...

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

---
 
Back
Top