Grey part of plot area

[cabUK]

I have created a gantt chart in Excel with the tasks going down one side and the dates across the top.

Basically somone wants me to shade previous days. In other words if the chart starts on the 1st Jan and its the 1st Feb he wants from the 1st Jan to 1st Feb dates shaded. With the remaning days left unshaded.

Is this possible? He has said he has seen it done but this is beyond my coding level. I would appreciate any help anyone can give on this.

Thanks in advance

Craig

 

[melone]

Use Conditional Formatting.....

 

[cabUK]

Sorry I forgot to mention the gantt chart has been done using a chart not the cells in excel.