Archive of Mr Excel Message Board
Back to Forms in Excel VBA archive index
Back to archive home
Conditional formating a data marker
Posted by Martin on September 06, 2001 3:37 PM
Is there a way to format a data marker so that its color corresponds to the value of its cell?
Re: Conditional formating a data marker
Posted by brent on September 06, 2001 4:25 PM
You're looking for something beyond opening the Format menu, picking Conditional Formatting and choosing between "Cell Value Is" and "Formula Is", for a value such as $A$1=n?
Re: Conditional formating a data marker
Posted by Martin on September 06, 2001 5:01 PM
Yes, once the chart is complete, is there a way to link the color of the data marker to the value of the cell it represents?
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.