Conditional Formatting and Moving a Trend Line

Hi

I have attached a screen shot of my xls and I am trying to do the following:

1) Apply conditional formatting so that if the date in Column B is in the future, the text is grayed out. (At the moment I am doing this manually).

2) I am trying to move the red trend line automatically on the graph to represent the current month. Again, I am doing this manually.

Thanks in advance for your help - this has been bugging me for ages!

David