Hi people,



I am making a schedule for 8 measurement stations (file is attached for convenience). What I'm trying to do is to make sure that the time from each measurement station does not overlap. In order for that to work, I need the conditional formatting function. The applied range for conditional formatting would be the same as every other rule, I presume (=$Y$3:$BDH$12).

The interesting columns are from E to X, which contains start time/date and end time/date (Gamry). If any of the 10 Gamry start time overlaps with eachother, I want those cells highlighted with red. I am not sure what else I can explain. Once you see the file, I am sure you will understand.

Thank you! Best regards
FNa

Attached Files

sync_tool_final_draft_FNa.xlsx (50.8 KB, 3 views)