If stmt

[mtapp2207]

I am looking for a simple stmt for the below:
If Cell B27 = Yes then Cell B28 is mandatory


Thank you

 

[Joe4]

Formula in cell B28:

=IF(B27="Yes","Mandatory","")

 

[mtapp2207]

=IF(B27="Yes","Mandatory","")

I apologize I wanted cell B28 to be a MANDATORY field not populate with the word Mandatory. Is that possible?

 

[Joe4]

I think that will require VBA.
Here is a link that shows you how you can do that: How to make a particular cell mandatory enter before closing workbook?

 

[mtapp2207]

Thank you I will give it a try

 

[Joe4]

You are welcome.