I tried Jon's method because it looked the most straightforward, but I
couldn't achieve the desired result.

Here's a description of the problem at hand: The Range that contains
the X-Values has the numbers 0,01 to 0,99 formatted as % i.e. they show
up in the spreadsheet at 1% to 99%. Y-values are in an adjacent column,
corresponding to some mathematical function. The function is plotted on
a smooth line XY-chart and the Chart is contained in a separate chart
sheet.

The Value on the X- axis that I like to highlight is 0,30 i.e. 30%.
The X-axis is scaled fron 0,00 (0%) to 1,00 (100%) with a primary
interval of 0,1(10%).

I doubleclicked the X-axis labels and formatted them as follows:

[Red][<0,3]0,00%;[Blue]0,00%
[Red][<0,3]0,00%;[Red][0,3]0,00%;[Blue]0,00%
[Blue][=0,3]0,00%;[Red]0,00%

All three format turned ALL x-labels Red! no Blue in sight! What went
wrong?

(There used to be a time when a hand-drawn function was quicker, albeit
less professional looking )


--
rvExcelNewTip
------------------------------------------------------------------------
rvExcelNewTip's Profile: http://www.excelforum.com/member.php...o&userid=15668
View this thread: http://www.excelforum.com/showthread...hreadid=501007