Formulas for Error Messages?

Hi there,

I wondered if someone could help.

So I have Some drop down boxes on my spread sheet

Drop downs.png

So when a user selects "sport" and "petrol" at the same time, I would like to display an error message.

Does anyone know if there's a formula for it or anything? I know errors can be done through data validation, but it seems like it only works for if a user tries to input their own option.

Any help would be appreciated.

Please upload your file

Please see attached.

Please Login or Register  to view this content.

Thank you for your reply. I know this probably sounds REALLY stupid (I'm a rookie!!) but where do I put the above?

Sorry, ignore me. You did it already. oops!