Hello,
I have a drop-down list data validation in one column, with the different statuses of an invoice. If an invoice was sent to the customer, the users need to change the status from "Not sent out" to "Pending payment" or "Paid", but they often forget to do so. The good part is that we have another column in the file with the invoice number allocated to a sent invoice. Therefore, I would want Excel to "check" if there are any non-blanks in the Invoice number field and display an error message reading: "The Invoice status selected is not valid. Please chose another value in the Invoice status column."
I have a drop-down list data validation in one column, with the different statuses of an invoice. If an invoice was sent to the customer, the users need to change the status from "Not sent out" to "Pending payment" or "Paid", but they often forget to do so. The good part is that we have another column in the file with the invoice number allocated to a sent invoice. Therefore, I would want Excel to "check" if there are any non-blanks in the Invoice number field and display an error message reading: "The Invoice status selected is not valid. Please chose another value in the Invoice status column."
