Hi Pecoflyer,

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.

To be honest, this was formatted by a former colleague and it works to this day, so we didn't examine the formula. We didn't need to change anything in the file until now!

Thank you for taking the time out to answer. I appreciate it!

Bests,
Fazal

Attached Files

sync_tool_final_draft_FNa_review.xlsx (50.9 KB, 5 views)