View Single Post
  #2   Report Post  
Frans van Zelm
 
Posts: n/a
Default

Dear Charles,

Next will be an ugly trick! But it works in a way, in Excel XP.
Put <spaces before all saturdays, sundays *and* mondays. Include these
cells when you create your chart.
The weekends will stand out by enlarged marker lines.

There will be a better way by using intelligent VBA. But I'm not
intelligent.

I first tried conditional formatting by
=OR(MOD(D6-38353;7)=0;MOD(D6-1-38353;7)=0)
That works fine in worksheet cells but it doesn't show in the chart.

Frans

"Charles" wrote in message
...
I have a chart and on the x axis I have days (January 1st 2005 - January

31
2005).
What I woul like to be able to do is HIGHLIGHT in red specific days (for
example weekends. In this case (Jan 1 and 2nd, 8, 9th, 15th, 16th, 22,23,

29
30) is this possible if so how (All other days in the x axis should remain

as
Black.
Thank you very much!
Regards Charles