Conditional Formatting Over 2 worksheets

Originally Posted by NBVC

So, in this workbook you attached, what should exactly be happening in Sheet2 and why?

In Sheet 2 if any of the questions are Blank or have an X i need the cell under monday to be Red

If all the cells for monday on sheet 1 have a tick mark then the cell needs to be green below monday.

Thanks