Conditional Formatting and IF Statements

Hello,

I need to put together a project plan and I have used a sample template. I am wanting to add some conditional formatting for the bars in the chart. I want to say if the 'end' date is today's date (and past today's date) and the '% done' is less than 100% then make the blue bars red in colour.

I have gone into the conditional formatting and have got as far as adding a new rule 'use a formula to determine which cells to format' but I really haven't a clue what to do next.

Attached Sample Sheet

Any help would be great.

Screen Shot.PNG

Thanks
Laura