How do I apply conditional formatting to axis labels?

I would like to apply conditional formatting to my horizontal axis based on
the value of that data point. If the value exceeds a threshold it would cause
the category axis label for that point to change font, color, etc.
or
I would like to apply conditional formating to a series based on the value
of the data point in the series. If the value excedds a threshold it would
cause the bar (bar graph) for that point to be different from the others.

Axis labels are treated as a unit, you can't format individual labels.

You could set up a dummy axis and use VBA to control its formatting. You
can see samples at Jon Poltier's website of dummy axes.

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

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"erwatt" wrote:

I would like to apply conditional formatting to my horizontal axis based on
the value of that data point. If the value exceeds a threshold it would cause
the category axis label for that point to change font, color, etc.
or
I would like to apply conditional formating to a series based on the value
of the data point in the series. If the value excedds a threshold it would
cause the bar (bar graph) for that point to be different from the others.