Need Help! Mandatory field with two cells, but one of them needs to be filled!

[dgavranovic]

I would like to make mandatory cell that one of the two cells needs to be filled.
F62 or H62, and if H62 is filled prompt to mandatory cell (B55 to K66) to give explanation!
I need to put this in already made code!
Thank you

[Kaper]

So .... show this "already made code"
probably in the place where you check whether H62 is filled you have to add few lines

for instance if you have something like (or may be with do ... loop?)

Please Login or Register  to view this content.

you could add a part to deal with checking H62 and then if it is not empty - enforcing user to fill additional cells

Please Login or Register  to view this content.

[dgavranovic]

Hi Kaper,
I have tried both formulas multiple times, and it seems that they do not do anything!
Thanks!
Am I missing something there?

[Kaper]

Which formulas?
If you mean my code samples - yes this code does nothing the real action shall be in places with comments, like:

Please Login or Register  to view this content.

Yeah, you missed (or I see it that way - may be I am wrong) at least two things:
1) quote from my post:

So .... show this "already made code"

2) quote from forum rules:

Post a WORKBOOK. Nobody wants to type data from a picture or paste text from your post into a spreadsheet as a prelude to helping. To attach a file, push the button with the paperclip (or scroll down to the Manage Attachments button), browse to the required file, and then push the Upload button.

[dgavranovic]

From xladept

Please Login or Register  to view this content.

Works like a charm!
Thanks again!