| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#9
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#11
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#12
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional format based on other cells | Excel Discussion (Misc queries) | |||
| Conditional format for cells. | New Users to Excel | |||
| Conditional Format based on Other Cells | Excel Discussion (Misc queries) | |||
| Conditional Format based on 3 other cells. | Excel Discussion (Misc queries) | |||
| Using MIN in Conditional Format for cells with Formulas | Excel Discussion (Misc queries) | |||
Linear Mode
