Auto checking for shift pattern errors

Hi,

Sample attached is of rota system I use, employees must have 11 hours between shifts. Working til 8 at night and starting at 7 in the morning although 11 hours is not acceptable.

Looking at the sample the following would cause an error
C7 & F7
C17 & F17
H11 & K11
M5 & P5
R8 & U8


Sheet 2 shows the result I would like to automatically display when an error occurs.
Solution to be for just one day not all days, as this will be amended and copied to specific areas for each day on actual workbook.

Thanks
Tez

That works great for highlighting cells on the same sheet and I will use this for the time being.

OP may not have been clear, when saying
"Sheet 2 shows the result I would like to automatically display when an error occurs."


I was looking to generate a text string containing the number of errors on a separate sheet as I already have multiple worksheets and that's why I thought VBA may be needed.

Thanks for the formula though.