conditional format cells with formula
 

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?

conditional format cells with formula
 

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

--

"amos" wrote in message
...
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?

conditional format cells with formula
 

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amos" wrote:
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?

conditional format cells with formula
 

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?

"PCLIVE" wrote:

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

--

"amos" wrote in message
...
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?

conditional format cells with formula
 

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

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amos" wrote:
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?

conditional format cells with formula
 

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?.


"amos" wrote:

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?

conditional format cells with formula
 

on the monitor...

"Mankind" wrote:

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?.


"amos" wrote:

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?

conditional format cells with formula
 

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?.


"amos" wrote:

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?

conditional format cells with formula
 

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" wrote in message
...
This is exactly what I want to do. However this has been suggested and
doesn't work. I have 2003.

"Max" wrote:

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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"amos" wrote:
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?

conditional format cells with formula
 

Your text didn't entirely come through - thanks though!

"Mankind" wrote:

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?.


"amos" wrote:

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?

conditional format cells with formula
 

?
on the monitor...
Max suggestion works for me...

"amos" wrote:

on the monitor...

"Mankind" wrote:

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?.


"amos" wrote:

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?

conditional format cells with formula
 

"amos" wrote:
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
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---