Highlighting Cell Depend On two criteria date and time

Hi All,

Hope anyone helpout me with it i have a workbook that have multiple sheets and a summary sheet ,
what i want in summary sheet
On Appointment time wise sheet we need date wise and time wise count of appointment generated on particular day. Total require count of appointment in specific time slot is 5. So if 4 appointment are there it should show green and as it cross 5 it should become red.