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
Bookmarks