I just got another great question from a student in my Microsoft Excel course on Udemy.
The question deals with automating a conditional check using VBA. One way to accomplish this would be create a custom function using VBA. I put together a quick video describing the process of creating a User Defined Function using VBA in Excel.
Download the exercise file and try it yourself: MDABFunction-01