Good Afternoon

I have an issue with conditional formatting in that excel will not allow it to go over 2 worksheets in a workbook.

On one sheet i have a set of questions with Yes or no answers or tick or cross whichever can be entered.

On the next sheet i have the list of days Monday - friday

I want to be able to change the cell to Green if all questions are completed and red if it has not been completed or there is a No or x in the box.

Is this possiable. It also has to stay on seperate sheets.

Many Thanks