Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Conditional formating the #Name? error message
Posted by Paul Martin on November 20, 2001 4:10 AM
I'm trying to graph data that varies in length and so to avoid having blank spaces on my graph when the data is shorter I have put in the 'else' section of my If statement N/A() as recommended on previous postings.
The problem with this is that i then can't put conditional formating on the cell so i have a unsigtly #Name? error on my worksheet that I was able to hide when leaving the else section blank.
Is there a way around this that I can keep the cell blank and also not plot it on the graph when it is blank? Many thanks
Re: Conditional formating the #Name? error message
Posted by Mark W. on November 20, 2001 6:35 AM
> ... i have a [unsightly] #Name?
Why do you have a #NAME? error? Have you
referenced a named range in your conditional
format?
> The problem with this is that i then can't
> put conditional formating on the cell...
Why not? What conditional formatting are you
attempting to use?
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.