"I think there will be goals," said the Scot. "I think both teams will score, but we have to think we can score more than them.
"There has been a massive build-up. You can see from the number of photographers at the training ground today - that is an indication of how important a game it is for both clubs.
"It's an occasion you always want to have and that's the beauty of the Champions League, you have the opportunity each year to play against one of the big teams from Europe. It is one of the biggest.
"I think both teams are in form. Real had two fantastic performances against Barcelona and found form at the right time for a game of this nature. Our form been consistent for quite a while which we need on Tuesday.
"I don't think it gets any bigger than this for a European night. It's set up to be a potentially marvellous game - I don't think we'll be disappointed."
United midfielder Michael Carrick is also expecting a memorable evening, saying: "These are the nights you live for. It is extra special. There is just something in the air. Everyone comes to the stadium with a spring in their step.
"Every supporter is that little bit more vocal. They appreciate how important it is and what it means to get through.
"The prestige and history of the club suggests we should be challenging in the later stages of these tournaments. It is up to us to go out there and do it."