conditional formatting with data labels?

[Dave R.]

I have a bar chart with data labels set up that are linked to cells. I have
a bunch of charts to make, so linking to cells was the way to go..

The problem is, even though the linked cells contain conditional formatting
to BOLD some of them, that bolding does not convey to the linked data
labels. Specifically I am trying to make them bold if another cell
(containing a significant p value) is not empty. This is what the
conditional formatting does but I would like it to convey to the labels, if
this is possible?

Thanks.

 

[Jon Peltier]

Dave -

You could use VBA to detect changed values, and reformat the labels. But that sounds like an
awful lot of work.

I have another idea, analogous to my conditional charting technique:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

In this example I have multiple columns of data, which only contain a value if a certain
condition is met. Each column is plotted in a differently formatted series, giving the
impression that the points are changing if the conditions change. Make your chart with two
series, one for each condition, and use data labels on each. One set of labels should be
formatted bold. You can also format the series differently if you want, to signify the
difference, or the same.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Dave R.]

Jon - good thinking! I'll give it a shot.

Dave -

You could use VBA to detect changed values, and reformat the labels. But that sounds like an
awful lot of work.

I have another idea, analogous to my conditional charting technique:

http://peltiertech.com/Excel/Charts/ConditionalChart1.html

In this example I have multiple columns of data, which only contain a value if a certain
condition is met. Each column is plotted in a differently formatted series, giving the
impression that the points are changing if the conditions change. Make your chart with two
series, one for each condition, and use data labels on each. One set of labels should be
formatted bold. You can also format the series differently if you want, to signify the
difference, or the same.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______