Hi Glenn,

Unfortunately, I could not convey exactly what was required. I added some assumed values and text boxes to give a better view.

The highlights are required in the schedule area i.e. $Y$3:$BDH$12 like the other rules defined. The start/end date column turning red when there is an overlap is a plus; however not necessary.

Thank you for taking the time out to answer. I apologize for the unclarity.

Bests,
Fazal

sync_tool_final_draft_FNa_review.xlsx