On entering an end or closed date, to check from blank or empty fields

[NRT10]

Hi,

Ive been struggling with an issue i have regarding cells being left blank once a closed date has been entered.

Ideally i would like excel to check the row of data for blank or empty cells when a date is entered into the 'Issue closed' field and generate a pop up message to "Please complete all cells". if all cells are filled then no message is required.

Hope i make sense.

thankyou in advance.

[Special-K]

Very little info to go on, so not much in the way of a reply.

Use Data Validation, be aware if a user can get round Data Validation by doing a copy/paste

[NRT10]

Hi sorry. I wasn’t sure how much info was required.

Basically cells A5,B5,C5 through to...J5 are to be completed. However when a date is entered in to K5 I’d like excel to check the cells A5 through to J5 for a blank cell and prompt with a message.

[Special-K]

Maybe

Data Validation Custom formula

=OR(K5="",AND(K5<>"",COUNTA(A5:J5)=10)

So if K5 is blank thats ok, if its not blank then all 10 cells need to have data in them.

[NRT10]

Thank you. I’ve used your formula and it works great. Would it be possible to have a dialogue box pop up when the rule above is false?

And thank you for the quick response.

[Special-K]

It's in the Data Validation section under the tab "Error Alert"

[NRT10]

Brill. Thank you!