Data Validation Custom Formula

[dmartinet]

I'm having trouble working through a Data Validation formula.

I have a merged cell with dropdown options (N5). If "MOC" is selected from the dropdown in N5, cell R5 must have something in it (it doesn't have to be anything specific - it just can't be blank).

Any help is most appreciated! Thank you!!

[JBeaucaire]

You could use Conditional Formatting on the R5 cell, if N5 is not blank and R5 is blank, turn the cell red. The Conditional Formatting formula would be:

=AND($N5<>"", $R5="")

[dmartinet]

Thanks for your help!! That would work but I have 19 different things that can selected from the dropdown in N5 but the only choice that would need more data in R5 is "MOC". The rest of the choices don't need that additional step.

I could use the conditional formatting method but I'd rather there be a big, fat notice that pops up to tell people there needs to be more informations with the MOC option and they can't move on without it.

[JBeaucaire]

The CF therefore would be:

=AND($N5="MOC", $R5="")



Popups like you're describing would require VBA.

[dmartinet]

This will work. Thank you!

[JBeaucaire]

As it appears you've reached a conclusion, I've marked this thread SOLVED for you.
FYI, this is done through the Thread Tools located above the first post in this thread. Thanks.

[dmartinet]

I see it now. Thanks again!