At the beginning of a formula you have:
.Formula = "=IF(OR($AF59="""",$AF59="""",$AJ59="""")
where $AF59 is checked twice; is this an unnecessary double check or should one of the $AF59s be different?