formulas/macros issue on my work

[kelvin_9]

i learning formulas, macros, conditional formatting..... and trying to speed up my work but i get some stuck on these kind of crazy stuff, can someone genius help me out?
sheet1_schedule: schedule deploy by my partner
sheet2_availability: availability from my teammate
sheet3_result: after formula/macro loading, i can easily & clearly see the mapping result

i got stuck and need to be fixed on: arkies & bella (ada is all fine)
column J&O for bella, she needs to end the shift before 20:00 on sunday and start after 13:45 on friday, but the outcome was "no-submit", i'd rather say it "wrong deploy by scheduler" instead of "no-submit" and then i can clearly find out and manually change it by myself.
column N for arkies, black by conditional formatting when cell is blank, can i change to "no-match"

<dl style="box-sizing: inherit; margin-right: 0px; margin-bottom: 1.5em; margin-left: 0px; color: rgb(51, 51, 51); font-family: Arial, Helvetica, sans-serif; background-color: rgb(252, 252, 252);"><dd id="direct-dl-link" style="box-sizing: inherit; margin: 0px 0px 0.8em; padding: 0px; color: rgb(34, 34, 34);">http://kel.ddns.net/f/04d86ec735/?raw=1</dd></dl>thanks,
kelvin

 

[kelvin_9]

hope someone can help on my stuck issue
thanks